Cell with cal/min

Closed
start1
Posts
1
Registration date
Friday February 1, 2013
Status
Member
Last seen
February 1, 2013
- Feb 1, 2013 at 09:05 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Feb 2, 2013 at 12:00 PM
Hello,

I want to calculate the (k)Cal/min in excel. I have a cell with start time defined in time and a cell with endtime (from a running session). in the third cell it calculates the time or minutes that I trained. I have the correct data of calories I used from a heartbeat watch and I manually enter this in a 4th cell.

now I want to calculate the cal/min.

if I use the 3rd cell output in a simple formula: 4thCell/3rdCell it does not give me what I want. what can I do?


1 reply

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Feb 2, 2013 at 12:00 PM
Hi start1,

Please put this formula in the third cell that calculates the time or minutes you trained:

= MINUTE(cell with end time- cell with start time)

Do reply with results.
0