If you want to change it to Excel time as in 1.5 hours turning into 01:30
you can just multiply all decimal values with 24 then format as hh:mm

--
Regards,

Peo Sjoblom

Portland, Oregon




"Debbie" wrote in message
...
I am trying to break down how much time is spent on each task throughout
and
8 hr dayto two decimal positions. there are 8 task and each one is using a
different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
figure
it out thanks