A2: Start time
B2: End time
Time before 18:00:
=IF(A2--"18:00",0,"18:00"-A2)
Time between 18:00 and 6:00:
=MIN(--"6:00",B2)-MAX(--"18:00",A2)+(MIN(--"6:00",B2)<MAX
(--"18:00",A2))
Time after 6:00:
=IF(B2<--"6:00",0,B2-"6:00")
This of course assumes that the start time is always in
the PM and the end time is always in the AM.
HTH
Jason
Atlanta, GA
-----Original Message-----
i I am working on a spreadsheet, where I need to know
how to Calculate
between two time formats, i.e. I want the cell to
calculate between 06:00 and
18:00 and 18:00 and 06:00. If some one starts work at
say 17:00 and finished
at 07:00 the following day, I need it to tell me how may
hours before 18:00,
then how many hours between 18:00 and 06:00, the how
many hours after 06:00.
If some one could help.
Thanks John
.
|