Calculate total time worked from ClockIn and Clock Out Info.

[rizmomin]

Hello:

Please refer to attached file.
I have clock inOut info as shown in attached sheet in cell I5 and J5.
I need a formula in K5 to calculate the number of hours worked in decimal format h.dd ( example .32).

Let me know if you have any questions.
Thanks.

[The_Snook]

Hi rizmomim,

Is this what you're trying to achieve?

In cell K5: =HOUR(J5-I5)+MINUTE(J5-I5)/60

NB - Don't forget to amend the cell format to 'Number' with 2 d.p.

Hope this helps?

Regards,

Snook

[rizmomin]

Hi The_Snook:

Thanks a lot, works great.

Riz