Skip to Content
Former Member
Oct 02, 2007 at 04:33 PM

Time duration formula help


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 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.