No, the result was 12:00:00 AM. Thank you for trying


"Ron Coderre" wrote:

It seems like your example is not a typical conversiion where 12.73 would be
12.73 hours.

If 12.73 means 12 hours and 73 minutes, they try this:

For a value in A1

B1: =(INT(A1)*60+(MOD(A1,1)*100))/(24*60)
or
B1: =(INT(A1)+(MOD(A1,1)*100/60))/(24)
Format the results as time

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Charlene" wrote:

I have the decimal number 12.73 and I want it to show as time, which should
be 13.13 ( 13 Hours and 13 Minutes). How do I do this?