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
Which example represents cell data with the date format applied to it? - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Based on the cell values in cells b77 - Excel Forum
Excel: If Date =, then enter a value ✓ - 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

help me to add particular cells

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

How to disable "Missed Call" history in WhatsApp chats

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!