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