dpetersman
New Member
- Joined
- Mar 26, 2009
- Messages
- 5
Hi,
I'm trying to calculate the total amount of hours between 2 dates and times in hours.
For example:
a1= date off duty
a2= time off duty
a3= date back on duty
a4= time back on duty
a5= number of hours and minutes between the date & time off duty and the date and time back on duty.
The problem im running into is when the duration spans more then 24 hours.
Any suggestions would be appreciated.
Dave
I'm trying to calculate the total amount of hours between 2 dates and times in hours.
For example:
a1= date off duty
a2= time off duty
a3= date back on duty
a4= time back on duty
a5= number of hours and minutes between the date & time off duty and the date and time back on duty.
The problem im running into is when the duration spans more then 24 hours.
Any suggestions would be appreciated.
Dave