Hi, can someone please help.
I have employees data regarding hours worked in a decimal format but
need to convert this to show hh:mm. So that 3.5 becomes 3:30.
I have tried dividing the original decimal by 24 and reformatting but
this only works for figures up to 24. How would I be able to say covert
103.25 hours into 103:15.
Is there a way of doing this?
Many thanks, Andrew
--
Shandy720
------------------------------------------------------------------------
Shandy720's Profile:
http://www.excelforum.com/member.php...o&userid=26230
View this thread:
http://www.excelforum.com/showthread...hreadid=474998