Working Hr. calculate

**Rahul Nagar** · 06-16-2009, 10:01 AM

Hello All,

Please check the attached file and please help me in this.

Thanks
Rahul

**martindwilson** · 06-16-2009, 10:02 AM

what file is that then?

**Rahul Nagar** · 06-16-2009, 10:04 AM

oohh

sorry

Please check now

**daddylonglegs** · 06-16-2009, 10:13 AM

In C2

=MOD(B2-A2,1)

format as h:mm and copy down

**martindwilson** · 06-16-2009, 10:22 AM

=IF(B2<A2,(B2-A2+1)*24,(B2-A2)*24) wil' give hours worked in decimal format e.g 9.5 (which is 9:30)
ah the old mod function i'm slipping badly today
but fyi you have to multiply by 24 if you want to calc overtime or such
=MOD(B2-A2,1)*24 gives same answer as above but is a tad shorter