Calculating time in minutes

[Kurt S]

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?

 

[Mike H]

Hi,

Multiiply by 1440 the number of minutes in a day formatted as general

=(C2-C1)*1440

Mike

 

[Peo Sjoblom]

Use custom format [mm]

--


Regards,


Peo Sjoblom

 

[Kurt S]

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.

Use custom format [mm]

--


Regards,


Peo Sjoblom

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?

 

[Peo Sjoblom]

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

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.

Use custom format [mm]

--


Regards,


Peo Sjoblom

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?

 

[Kurt S]

Ah, thanks for the clarification. You're right, I didn't use the brackets.

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

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.

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?

 

[Peo Sjoblom]

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

Ah, thanks for the clarification. You're right, I didn't use the brackets.

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

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.

:

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?

 

[Kurt S]

Great info. Thanks again for the help.

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

Ah, thanks for the clarification. You're right, I didn't use the brackets.

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



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.

:

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?

 

[Kurt S]

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.

Great info. Thanks again for the help.

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

Ah, thanks for the clarification. You're right, I didn't use the brackets.

:

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



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.

:

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?

 

[Peo Sjoblom]

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

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.

Great info. Thanks again for the help.

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




Ah, thanks for the clarification. You're right, I didn't use the
brackets.

:

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



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.

:

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?

 

[Kurt S]

The [mm];; worked perfect. That's exactly what I wanted. Again, thanks for
all your help.

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

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.

Great info. Thanks again for the help.

:

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




Ah, thanks for the clarification. You're right, I didn't use the
brackets.

:

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



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.

:

Use custom format [mm]

--


Regards,


Peo Sjoblom



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?