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?

Cell with cal/min
If cell contains date then return value ✓ - Office Software Forum
Conditional formatting if cell contains text - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

1 response

Answer 1 / 1

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

Similar discussions

Counting cells containing only numbers

help me to add particular cells

If a cell contains any text then add a value

How to use conditional format based on text?

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!