Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
I am trying to calculate time and I am not sure if I have them listed in the
appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
Format the cells as [mm]:ss
but enter the values as: 00:12:12 -- Gary''s Student - gsnu200826 "Erika" wrote: I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
Enter the data with hours as well, 0:12:12, and so on, then format the sum
cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
That worked great and I get the result of 84:17:00 - now I need to take that
and divide it by 3. When I do that I get 252:51:00 - 252 is the answer I am looking for but when I try to convert that to currency is give me $10.54 is it because I have a time format and a dollar amount that I am working with - is there any way around this? "Bob Phillips" wrote: Enter the data with hours as well, 0:12:12, and so on, then format the sum cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
I assume that when you divide by 3, you intended to say multiply by 3?
If you want the answer as a decimal number of hours, rather than an Excel time, multiply by 24 and format the result as number or general, not time. The reason that you are seeing 10.54 is that 252 hours 51 minutes is 10.54 days, and Excel calculates time in multiples of a day. -- David Biddulph Erika wrote: That worked great and I get the result of 84:17:00 - now I need to take that and divide it by 3. When I do that I get 252:51:00 - 252 is the answer I am looking for but when I try to convert that to currency is give me $10.54 is it because I have a time format and a dollar amount that I am working with - is there any way around this? "Bob Phillips" wrote: Enter the data with hours as well, 0:12:12, and so on, then format the sum cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
You are correct I did intent to say multiple. When I multiple 84:17 by 3 I
am looking to get a result of 84 minutes multiplied by $3. Resulting in 252 but I need that as a figure that I can calculate with other numbers. If I just need to enter 84 by hand I can do that I was just wondering if Excel would be able to. "David Biddulph" wrote: I assume that when you divide by 3, you intended to say multiply by 3? If you want the answer as a decimal number of hours, rather than an Excel time, multiply by 24 and format the result as number or general, not time. The reason that you are seeing 10.54 is that 252 hours 51 minutes is 10.54 days, and Excel calculates time in multiples of a day. -- David Biddulph Erika wrote: That worked great and I get the result of 84:17:00 - now I need to take that and divide it by 3. When I do that I get 252:51:00 - 252 is the answer I am looking for but when I try to convert that to currency is give me $10.54 is it because I have a time format and a dollar amount that I am working with - is there any way around this? "Bob Phillips" wrote: Enter the data with hours as well, 0:12:12, and so on, then format the sum cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
=time_in_mins*3*24*60
-- __________________________________ HTH Bob "Erika" wrote in message ... That worked great and I get the result of 84:17:00 - now I need to take that and divide it by 3. When I do that I get 252:51:00 - 252 is the answer I am looking for but when I try to convert that to currency is give me $10.54 is it because I have a time format and a dollar amount that I am working with - is there any way around this? "Bob Phillips" wrote: Enter the data with hours as well, 0:12:12, and so on, then format the sum cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate and Format Time
Do it as per the part where I said:
"If you want the answer as a decimal ..., rather than an Excel time, multiply by 24 and format the result as number or general, not time." ? -- David Biddulph Erika wrote: You are correct I did intent to say multiple. When I multiple 84:17 by 3 I am looking to get a result of 84 minutes multiplied by $3. Resulting in 252 but I need that as a figure that I can calculate with other numbers. If I just need to enter 84 by hand I can do that I was just wondering if Excel would be able to. "David Biddulph" wrote: I assume that when you divide by 3, you intended to say multiply by 3? If you want the answer as a decimal number of hours, rather than an Excel time, multiply by 24 and format the result as number or general, not time. The reason that you are seeing 10.54 is that 252 hours 51 minutes is 10.54 days, and Excel calculates time in multiples of a day. -- David Biddulph Erika wrote: That worked great and I get the result of 84:17:00 - now I need to take that and divide it by 3. When I do that I get 252:51:00 - 252 is the answer I am looking for but when I try to convert that to currency is give me $10.54 is it because I have a time format and a dollar amount that I am working with - is there any way around this? "Bob Phillips" wrote: Enter the data with hours as well, 0:12:12, and so on, then format the sum cell as [m]:ss -- __________________________________ HTH Bob "Erika" wrote in message ... I am trying to calculate time and I am not sure if I have them listed in the appropriate format. I need them in a minute and second format. I want to add up the following and get the total in a minute and second format as well then in another cell I want to multiple the total minutes by 3. 12:12 13:02 11:03 12:03 23:23 12:34 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total time(hours/minutes) from text/custom format column | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Format & calculate time sheet template | Excel Discussion (Misc queries) | |||
aps3 calculate diff in time and cinvert into another format | Excel Worksheet Functions | |||
How to calculate speed given distance and mm:ss time format? | Excel Discussion (Misc queries) |