"mama no teeth" wrote in message
...

E1 =(B1-A1)+(D1-C1+1)

A word of caution. Whilst this works for the times given, if the last time
was in the same day as the other times, for example at 23:00, then it would
be adding one day to the time, giving an actual result of 31:10 masked by
the formatting to show as only 7:10. (Reformat the cell as [h]:mm to see).
5 days would add up to 155.50 hours (formatted as [h]:mm), instead of the
correct result result 35:50.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"mama no teeth" wrote in message
...
Assuming
A1= 15:00
B1= 18:30
C1= 19:20
D1= 02:00

E1 =(B1-A1)+(D1-C1+1)

"Kjaltrik" wrote:

I'm making a timesheet and it's working good.
But I can't work out how to calculate mu working time from ex: 15:00 to
18:30 lunchbreak and then 19:20 to 02:00. The calculated anser I get is
"-13.83"

I hope somebody can help me

Thanx