convertions

  • Thread starter Thread starter Olivia Benit
  • Start date Start date
O

Olivia Benit

I am trying to complete the following convertion, but can
not figure out the formula:

employee time sheet: column 1 (time in)
column 2 (time out)
column 3 (convertion)

Column 1 Column 2 Column 3
08:15:32 04:38:25 formula to convert to
# of hours (nearest 100th)

Anyone?!
 
Hi Olivia
what do you mean with nearest 100th (rounding to the minute?)
try in C1
=ROUND((B1-A1)*24*60,0)/(24*60)
and format this as time

If your working time can span midnight use
=ROUND((B1-A1+(B1<A1))*24*60,0)/(24*60)
 
Back
Top