Cell with cal/min

[Closed]
Report
Posts
1
Registration date
Friday February 1, 2013
Status
Member
Last seen
February 1, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
44
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.