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?
--
Thank You, Wendy

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

"Wendy" wrote:

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?
--
Thank You, Wendy

* 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

Użytkownik "Wendy" napisał w wiadomości
...
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?
--
Thank You, Wendy

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

Użytkownik "tomek gomek" napisał w wiadomości
...
* 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

Użytkownik "Wendy" napisał w wiadomości
...
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?
--
Thank You, Wendy