Convert Hours and Minutes to a decimal

[Mel Smith]

I would like to convert total time, expressed as HH:MM into a decimal. e.g. 49:30 to 49.50. Can anyone assist, please?

Mel

 

[jasonb75]

Multiply it by 24 and format as number.

You will need to add a couple of functions if any kind of rounding is required. Usually one of CEILING, FLOOR or MROUND is sufficient but it would depend on the exact requirement.

 

[Mel Smith]

Hi Jason,

Thanks for your reply, which works perfectly, thank you!