Converting decimal time to standard time?

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" <mpendleton.27nwto@news.officefrustration.com> wrote in message
news:mpendleton.27nwto@news.officefrustration.com...
>
> 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

Try:

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

Ben