Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
I have a spreadsheet that I enter the start and end times of a project. I
would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Hi,
Multiiply by 1440 the number of minutes in a day formatted as general =(C2-C1)*1440 Mike "Kurt S" wrote: I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Use custom format [mm]
-- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Thanks for the answers guys. Mike, your formula worked great. Peo, I had
tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Actually, it will give you the total minutes. I am sure you overlooked that
I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Ah, thanks for the clarification. You're right, I didn't use the brackets.
"Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
If you intend to do calculation like if you have pay rates
that use minutes than you should convert it to decimal by multiplying with 1440 (60*24), if not it is better to use a custom format since it will save a little bit of computing resources. [hh]:mm will display hours 24 and greater. x*24 formatted as general or number will be the equivalent decimal hours -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ah, thanks for the clarification. You're right, I didn't use the brackets. "Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Great info. Thanks again for the help.
"Peo Sjoblom" wrote: If you intend to do calculation like if you have pay rates that use minutes than you should convert it to decimal by multiplying with 1440 (60*24), if not it is better to use a custom format since it will save a little bit of computing resources. [hh]:mm will display hours 24 and greater. x*24 formatted as general or number will be the equivalent decimal hours -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ah, thanks for the clarification. You're right, I didn't use the brackets. "Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
Ok one ore question. If I enter that formula into a cell, it will default to
puting two 0's in the cell until data is put in the other cells. Is there any way to have it not show a 00 value until data is entered in the other cells. It's no big deal, just looks cleaner if there aren't a bunch of 0's in the spreadsheet. "Kurt S" wrote: Great info. Thanks again for the help. "Peo Sjoblom" wrote: If you intend to do calculation like if you have pay rates that use minutes than you should convert it to decimal by multiplying with 1440 (60*24), if not it is better to use a custom format since it will save a little bit of computing resources. [hh]:mm will display hours 24 and greater. x*24 formatted as general or number will be the equivalent decimal hours -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ah, thanks for the clarification. You're right, I didn't use the brackets. "Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
If there can never be a zero value you can use
[mm];; as a custom format, if it is OK with one zero you can use [m] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ok one ore question. If I enter that formula into a cell, it will default to puting two 0's in the cell until data is put in the other cells. Is there any way to have it not show a 00 value until data is entered in the other cells. It's no big deal, just looks cleaner if there aren't a bunch of 0's in the spreadsheet. "Kurt S" wrote: Great info. Thanks again for the help. "Peo Sjoblom" wrote: If you intend to do calculation like if you have pay rates that use minutes than you should convert it to decimal by multiplying with 1440 (60*24), if not it is better to use a custom format since it will save a little bit of computing resources. [hh]:mm will display hours 24 and greater. x*24 formatted as general or number will be the equivalent decimal hours -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ah, thanks for the clarification. You're right, I didn't use the brackets. "Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time in minutes
The [mm];; worked perfect. That's exactly what I wanted. Again, thanks for
all your help. "Peo Sjoblom" wrote: If there can never be a zero value you can use [mm];; as a custom format, if it is OK with one zero you can use [m] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ok one ore question. If I enter that formula into a cell, it will default to puting two 0's in the cell until data is put in the other cells. Is there any way to have it not show a 00 value until data is entered in the other cells. It's no big deal, just looks cleaner if there aren't a bunch of 0's in the spreadsheet. "Kurt S" wrote: Great info. Thanks again for the help. "Peo Sjoblom" wrote: If you intend to do calculation like if you have pay rates that use minutes than you should convert it to decimal by multiplying with 1440 (60*24), if not it is better to use a custom format since it will save a little bit of computing resources. [hh]:mm will display hours 24 and greater. x*24 formatted as general or number will be the equivalent decimal hours -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Ah, thanks for the clarification. You're right, I didn't use the brackets. "Peo Sjoblom" wrote: Actually, it will give you the total minutes. I am sure you overlooked that I used [mm] note the brackets. You probably used mm which will only go up to 59 minutes However if you include the brackets it will show larger values -- Regards, Peo Sjoblom "Kurt S" wrote in message ... Thanks for the answers guys. Mike, your formula worked great. Peo, I had tried that already. It just gave me the minutes, and didn't calculate the hours into minutes. "Peo Sjoblom" wrote: Use custom format [mm] -- Regards, Peo Sjoblom "Kurt S" wrote in message ... I have a spreadsheet that I enter the start and end times of a project. I would like to be able to calculate the time spent in minutes. IE. I enter the time I started in cell C1 and the end time in cell C2. If I enter the formula "=C2-C1" it will calculate the time, but it does it in hours and minutes. What formula can I use to calculate the time in minutes only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Minutes from and Time Based Calculation | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating time, hours and minutes | Excel Discussion (Misc queries) | |||
Calculating time difference in minutes | Excel Worksheet Functions | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) |