Calculate number of hours worked

Re: Calculate number of hours worked

Take a look at this -- Employee Time Sheet

Re: Calculate number of hours worked

Quote from sabal87;679028

I tried looking at old threads, but I can't seem to find anything that works for my case.

I have a time sheet similar to the one below.

[TABLE="width: 500"]

[tr]

[td]

day

[/td]

[td]

time in

[/td]

[td]

time out

[/td]

[td]

time in

[/td]

[td]

time out

[/td]

[td]

hours worked

[/td]

[/tr]

[tr]

[td]

Monday

[/td]

[td]

8:30

[/td]

[td]

4:30

[/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

Tuesday

[/td]

[td]

8

[/td]

[td]

12:30

[/td]

[td]

1:30

[/td]

[td]

5

[/td]

[td][/td]

[/tr]

[/TABLE]

I'm trying to write a code to calculate the hours worked (in both cases 8 for the example above). I've tried different number formats, but I can't find one that works.

Any ideas or comments would be greatly appreciated

Display More

Are the only two formats or you can have more?
Is this 8:30 4:30 morning or afternoon?
How do you know this?

Re: Calculate number of hours worked

Try:

F2 drag down
=IF(C2<>"", C2-B2+E2-D2,C2-B2)
format as h

Re: Calculate number of hours worked

=IF(C2<>"",(C2-B2+E2-D2)*24,(C2-B2)*24)
Format as General