Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
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 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
Hi 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 "Anne Troy" wrote: 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 "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
Peo,
you can just multiply all decimal values with 24 then format as hh:mm I assume you mean divide by 24 not multiply -- Regards Sandy with @tiscali.co.uk "Peo Sjoblom" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format time
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 "Sandy Mann" wrote in message ... Peo, you can just multiply all decimal values with 24 then format as hh:mm I assume you mean divide by 24 not multiply -- Regards Sandy with @tiscali.co.uk "Peo Sjoblom" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
convert number to time format? | Excel Discussion (Misc queries) |