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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?