how do I change time data to numerical result

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I find the amount of hours between times? 1
How to calculate Premium Time 2
Time Sheets 2
Converting time-formatted to text-based data 2
Time Calculation 6
Giving a letter a numerical value 6
Time calculations 3
which one to use: Macros / Formula's / Lookup 4

Top