Converting Time from Hours:Minutes to number of hours

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

Guest

HELP!
I am trying to find a formula that will convert hours:minutes to be total
hours diplayed as a decimal.
eg. Total worked Time = 50:30 (50hrs:30min) would convert to 50.5 hours

Any help would be greatly appreciated.
 
Leslie,

use total time * 24.

Please note that XL in its wisdom will probably format the answer i
hours & minutes.
Change the cell format to number and you should be O
 
If in A1: 50:30,
where A1 is custom formatted as: [h]:mm

Try in say B1: =A1*24
Format B1 as: General or Number
B1 will return: 50.5
 
Say A1 has 50:30 in it and you want B1 to have the
decimal equivalent, enter the following in B1:
=A1*24
Then ensure B1 is formatted as a number
 
Back
Top