calculate time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DarkNight - 23 Apr 2007 09:32 GMT

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

Reply to this Message

Mike H - 23 Apr 2007 12:38 GMT

Hi,

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

=IF(A2>A3,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

> Hello, i've got a little problem with time.
> A2 = 22:00 ( start time )
[quoted text clipped - 9 lines]
> i'm sure this will be easy to someone but i'm clueless.
> thanks for any help given

Reply to this Message

DarkNight - 23 Apr 2007 19:42 GMT

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

> Hi,
>
[quoted text clipped - 23 lines]
> > i'm sure this will be easy to someone but i'm clueless.
> > thanks for any help given

Reply to this Message

Rate this thread: