• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Excel - Time function

How to convert time duration (e.g. 4:08:58 AM - 4:02:11 AM) to minutes?
pax
0
cpeters5
Asked:
cpeters5
1 Solution
 
ScriptAddictCommented:
this is done very easy by using a custom format such as :

I'd break it into two columns.  One with the end time and one as the start time

subtract the start time from the end time in a third cell and then I'd just use a custom format mm:ss on the third cell.  


and that would work!
0
 
barry houdiniCommented:
If the time difference might be more than an hour (and you still want to display just minutes and seconds) then custom format has to be like

[m]:ss

in order to show minutes > 59

regards, barry
0
 
cpeters5Author Commented:
thank you
0
 
archersloCommented:
=TIMEVALUE("4:08:58 AM")-TIMEVALUE("4:02:11 AM")

Use the Format Cells command (Number tab) to select Time and the Type that reads: 30:55.2

This will render a result of 06:47.0
2012-09-04-10-44-59-AM.gif
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now