[Wactclc-alma] Combining Date and Time for calculation

[Sally Sheedy]

Hi All,

We are looking at data to see if our policies are set to maximally serve patrons' needs.

I've been asked to do an analysis of how long our two-hour items are out for and that won't be too difficult because you can assume the same day. In fact, we will ignore the outliers for items that are seriously late.  But I want to compare date AND time for Loaned and Returned for overnight and three-day loans. I can do this in Excel but I don't know how to add the date and time fields together in Analytics/SQL. I'd like to be able to use bins instead of grouping Pivot tables in Excel.

Any ideas?

Thanks!

Sally Sheedy
Systems Librarian
Whatcom Community College Library
237 West Kellogg Road
Bellingham, WA 98226
360-383-3287  (library 3300, college 3000)
ssheedy at whatcom.edu
library.whatcom.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181207/13c66d43/attachment.html>