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?
|