how do I change time data to numerical result

J

J. Gorman

I am trying to create a roster spread sheet to calculate amount of hours and
cost. I would like to know how to change my result from formula. i.e.
8h:30min to 8.5 hours?
 
R

Ragdyer

If your data is truly in the format of hh:mm, then simply multiply by 24,
and format the cell as number or General.
 
Top