Question Locked

Calculate time in Excel 2003

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Question: I need to be able to calculate the amount of time in hours:minutes between one date/time and another. I can subtract one from the other and format the output but I need to also subtract weekend days and evenings (a 8-5 workday).

I can get the net working days (networkdays) but that's not what I want.
Is there an easier way than writing a custom function? If not, can someone provide general pseudocode for the algorithm. Thank you.

Example: If the start value is 12/17/2004 16:00 and the end value is 12/21/2004 10:20 the result should be 12:20.

4 replies

by rrhenius

Hi!
Did you get it?
I have a zero (error) time result problem (like "overtime for 17:00 - 8:00 - 1 h lunch") and an overtime calc prob for someone who got in one day (say 9:00 and leaved next day at 1:00 - end time less thand star time)
Rgds Rolf

This discussion is closed to new replies.