software

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

Hi, Debbie. I'm afraid you're going to have to rephrase your question or
explain a little more. I cannot understand what the problem is. Perhaps
someone else can.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

quot;Debbiequot; gt; wrote in message
...
gt;I am trying to break down how much time is spent on each task throughout
gt;and
gt; 8 hr dayto two decimal positions. there are 8 task and each one is using a
gt; different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
gt; figure
gt; it out thanks
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

quot;Debbiequot; gt; wrote in message
...
gt;I am trying to break down how much time is spent on each task throughout
gt;and
gt; 8 hr dayto two decimal positions. there are 8 task and each one is using a
gt; different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
gt; figure
gt; it out thanksHi Anne, I read your response and I am going to try and explain the best that
I can. I am making a spreadsheet for a class I am in. So this is how it is
suppose to be. breakout of job responsibilities is the title of the
spreadsheet and im suppose to break down how much time in a day or 8 hours
that a person spends doing each task. such as answering phones is 1.5,
greeting customers 1.0,creating documents1.5 ect. then i am to format hours
/day in task to two decimal positions. does this explain any better

quot;Anne Troyquot; wrote:

gt; Hi, Debbie. I'm afraid you're going to have to rephrase your question or
gt; explain a little more. I cannot understand what the problem is. Perhaps
gt; someone else can.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt; Check out: www.ExcelUserConference.com
gt;
gt; quot;Debbiequot; gt; wrote in message
gt; ...
gt; gt;I am trying to break down how much time is spent on each task throughout
gt; gt;and
gt; gt; 8 hr dayto two decimal positions. there are 8 task and each one is using a
gt; gt; different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
gt; gt; figure
gt; gt; it out thanks
gt;
gt;
gt;

Peo,

gt; you can just multiply all decimal values with 24 then format as hh:mm

I assume you mean divide by 24 not multiply

--
RegardsSandy
with @tiscali.co.ukquot;Peo Sjoblomquot; gt; wrote in message
...
gt; If you want to change it to Excel time as in 1.5 hours turning into 01:30
gt; you can just multiply all decimal values with 24 then format as hh:mm
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Debbiequot; gt; wrote in message
gt; ...
gt;gt;I am trying to break down how much time is spent on each task throughout
gt;gt;and
gt;gt; 8 hr dayto two decimal positions. there are 8 task and each one is using
gt;gt; a
gt;gt; different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
gt;gt; figure
gt;gt; it out thanks
gt;
Yep, you got that right. Thanks for the correction.
I am so used doing it the other way around for the purpose
of multiplying with a payrate

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Sandy Mannquot; gt; wrote in message
...
gt; Peo,
gt;
gt;gt; you can just multiply all decimal values with 24 then format as hh:mm
gt;
gt; I assume you mean divide by 24 not multiply
gt;
gt; --
gt; Regards
gt;
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk
gt;
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt;gt; If you want to change it to Excel time as in 1.5 hours turning into 01:30
gt;gt; you can just multiply all decimal values with 24 then format as hh:mm
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Debbiequot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I am trying to break down how much time is spent on each task throughout
gt;gt;gt;and
gt;gt;gt; 8 hr dayto two decimal positions. there are 8 task and each one is using
gt;gt;gt; a
gt;gt;gt; different amount of time. 1.5, 1.0, 1.5, 0.75,2.0, 0.75, 7.5. I cannot
gt;gt;gt; figure
gt;gt;gt; it out thanks
gt;gt;
gt;
gt;