Need help with cell formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a timesheet for our payroll system. I have a row where
employees enter the times they punch in and out each day then at the end of
the row there is a function to automatically total the number of hours
worked. My problem is that the punch-in and punch-out entries are in an
(h:mm) format and I need the cell containing the total to be in a decimal
format. How do I format it so that working 8 hours and fifteen minutes shows
up in the total column as 8.25 rather than 8.15?
 
Start in A1
End in B1
Format C1 to General or Number, then enter
=MOD(B1-A1,1)*24

The Mod is for times spanning midnight.
 
Assuming that the times are real XL times then to turn tham into decimal
numbers multiply the total by 24

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top