Excel 2007 calculate time between 2 date/time columns
I am using Excel 2007 and trying to calculate the actual time it takes to
pick orders.
Work day starts at 06:00 and ends at 20:00. using simple [end time] -
[start time] calulation. How do i calculate the hours if the job goes in to
the next day? I am a novice, as you can tell, but desperate to learn.
Kevo
|