Hello, i've got a little problem with time.
A2 = 22:00 ( start time )
b2 = 7:00 ( finish time )
c2 = 1:30 ( breaks )
d2 = 7:30 ( hours worked less breaks )
e2 = hours worked between 6pm and midnight ( formula required please )
f2 = hours worked between midnight and 6am ( formula required please )
g2 = hours worked between 6am and 6pm ( formula required please )

i've looked on the forums and found out how to workout how to calculate d2
but need formulas for e2,f2,g2
i'm sure this will be easy to someone but i'm clueless.
thanks for any help given

Hi,

Try this in E2 (Formatted [h]:mm) for the hours worked between 18:00 and
midnight:-

=IF(A2A3,A4-A2,(A4-A2)-(A3-A2))

For this cell A3 contains the time 18:00 and cell A4 contains the time
24:00. You can stick these somewhere out of the way.

Following this logic you should be able to work out your other formula.

Mike

"DarkNight" wrote:

Hello, i've got a little problem with time.
A2 = 22:00 ( start time )
b2 = 7:00 ( finish time )
c2 = 1:30 ( breaks )
d2 = 7:30 ( hours worked less breaks )
e2 = hours worked between 6pm and midnight ( formula required please )
f2 = hours worked between midnight and 6am ( formula required please )
g2 = hours worked between 6am and 6pm ( formula required please )

i've looked on the forums and found out how to workout how to calculate d2
but need formulas for e2,f2,g2
i'm sure this will be easy to someone but i'm clueless.
thanks for any help given

Thanks Mike H,
works a treat, just had to change 24:00 to 00:00 for hours between midnight
and 6am.

"Mike H" wrote:

Hi,

Try this in E2 (Formatted [h]:mm) for the hours worked between 18:00 and
midnight:-

=IF(A2A3,A4-A2,(A4-A2)-(A3-A2))

For this cell A3 contains the time 18:00 and cell A4 contains the time
24:00. You can stick these somewhere out of the way.

Following this logic you should be able to work out your other formula.

Mike

"DarkNight" wrote:

Hello, i've got a little problem with time.
A2 = 22:00 ( start time )
b2 = 7:00 ( finish time )
c2 = 1:30 ( breaks )
d2 = 7:30 ( hours worked less breaks )
e2 = hours worked between 6pm and midnight ( formula required please )
f2 = hours worked between midnight and 6am ( formula required please )
g2 = hours worked between 6am and 6pm ( formula required please )

i've looked on the forums and found out how to workout how to calculate d2
but need formulas for e2,f2,g2
i'm sure this will be easy to someone but i'm clueless.
thanks for any help given