How can I convert time in decimal to hh:mm format?

garyrobbins
garyrobbins used Ask the Experts™
on
Hello experts again,

I have a column showing time in decimal format (days) [ thanks to Mr Wizard, rorya].  Can you help me with the conversion formula (and format) for hours and minutes -- see Column G?

Thanks,
Gary
Mikes-Report---Weekly-Hours-c---.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011
Commented:
Select the cells, press Ctrl+1, choose Custom on the Number Format tab and enter:
[h]:mm
as the format.
you could aslo do =F3*24 in Cell G3 and then drag down

Author

Commented:
Thanks again, rorya.  You make this look simple.

Gary

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial