Time Formulae

[breenio]

I need to formulate cells to give duration.
In otherwords, I need to formulate cells to subtract a finish time from start time and get the duration in mins
HOW????????????
It has been doing my head in for hours

 

[Brian from Maui]

Try this thread

http://www.mrexcel.com/board/viewtopic.php?topic=3001&forum=2&start=20

or this:

http://www.mrexcel.com/board/viewtopic.php?topic=3139&forum=2
This message was edited by Brian from Maui on 2002-03-24 03:21

 

[breenio]

I will have a go

Ta

 

[Dave Hawley]

Hi Breenio

Let's say you have your start time in cell A1 and End time in B1.

=($B$1-$A$1)*1440

Will give you the amount of minutes.

A better way however might be to just use:
=($B$1-$A$1)

And Custom format the cells as:
[m]