Converting Time from Hours:Minutes to number of hours

[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.

 

[Kieran]

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

 

[Max]

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

 

[Andrew]

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