Excel convert Time to Decimal

[ebisabes]

is it possible to take a cell formatted as h:mm or 13:30 and convert it in an adjacent cell to 13.5 ????

I thought it should have been possible with =(RIGHT(A1,2))/60
at least to tell me what the minutes equal as a decimal, but I don't know how the formula cell should be formatted & every way I have tried gives me a very strange & incorrect number.

Thanks for any ideas & I will give them a try ;-)

 

[AnotherHiggins]

[COLOR=blue white]=A1*24[/color]

Format as general.

Right() doesn't work because 13:30 is only a format - the actual serial number contained in the cell is .5625

See faq68-5827, Why do Dates and Times seem to be so much trouble? for more info on how Excel deals with dates and times.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

Why do Dates and Times seem to be so much trouble? faq68-5827

Convert the TIME portion of the VALUE from DAYS to HOURS.
[tt]
=(A1-INT(A1))*24
[/tt]


Skip,
[sub]
[red][/red]
[/sub]