Converting decimal time to standard time?
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
|