I am working on a formula spreadsheet and can NOT figure out how to
convert time that would include hours to standard time. For instance
if someone worked 7.25 hours it is 7 hours and 15 minutes. which would
read 7:15. Can anyone help.


--
mpendleton

=A1/24

where A1 holds 7.25, format as hh:mm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"mpendleton" wrote in message
. ..

I am working on a formula spreadsheet and can NOT figure out how to
convert time that would include hours to standard time. For instance
if someone worked 7.25 hours it is 7 hours and 15 minutes. which would
read 7:15. Can anyone help.


--
mpendleton

I tried the A1/24 it didn't work. See b2+c2+d2 = e2. e2 is what I am
tring to convert to the 24 hours. any other suggestions. thanks
I am working on a formula spreadsheet and can NOT figure out how to
convert time that would include hours to standard time. For instance
if someone worked 7.25 hours it is 7 hours and 15 minutes. which would
read 7:15. Can anyone help.


--
mpendleton

So the sum of B2:D2 = 7.25 and that is what you want to convert in E2?

In E2,

=sum(B2:D2)/24

and format hh:mm

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541322

Try:

=TRUNC(A1) & ":" & (A1-TRUNC(A1))*60


Ben


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=541322