Calculating Mintues

W

Wendy

I want to find the number of minutes from one day/time to the next day/time
based on an eight hour work day. For Example: 07/16/07 10:00 am to 07/17/07
9:00 am. But each day is only and 8 hour shift. Anyone have any idea how to
do this?
 
T

Toppers

In your example, the number of hours is 23 ... how does the 8 hour shift
relate to this?
 
T

tomek gomek

* date format is from Poland :) *

a1: 2007-07-16 10:00:00
b1: 2007-07-17 09:00:00
c1: =B1-A1-CZAS(16;0;0)

CZAS means TIME i think

i hope you expect it
in this way i understood your post
 
T

tomek gomek

of course this works for work day from 6am to 2pm.
for example from 7am to 3pm instead of time(16...) must be time(18...) .....

regards
tomek
 
Top