Post Author: ztruelove
CA Forum: Formula
I am needing to run a monthly report that shows how many hours our company cars have been "checked out" for that particular month. Each record has a "check out date" field in the format YYYY-MM-DD and a "check out time" field in the format 17:00:00 (and two more fields for check in date and time). My questions are...
1) How do I extract only the hours for the month I'm reporting on? Say I'm reporting on October, and the car was checked out on September 29th and returned on October 2nd...how do I just pull the October hours?
2) I just want to see "business hours" of 08:00 - 17:00. So if the car was checked out on Friday, October 5th at 17:01 and checked back in on Tuesday, October 9 at 12:00, I would want to see a duration of 13 hours (9 hours from Monday and 4 hours from Tuesday).
Any suggestions or assistance is greatly appreciated.