lzweifel
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 213
Can I create a formula to calculate hours overlapping from one day to the next without entering the date. For example...
7:30 pm - 1:30 pm (start work at 7:30 pm and return next day at 1:30 pm) total hours 18 hours.
I know it works if I put in 03-18-10 7:30 pm and 03-19-10 1:30 pm, but I don't really want the date in this column.
Thanks!
7:30 pm - 1:30 pm (start work at 7:30 pm and return next day at 1:30 pm) total hours 18 hours.
I know it works if I put in 03-18-10 7:30 pm and 03-19-10 1:30 pm, but I don't really want the date in this column.
Thanks!