Hi

The formula is same, but use format "[h]:mm"


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Shandy720" wrote
in message ...

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