Time Formulae

breenio · Mar 24th, 2002, 04:13 AM

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 · Mar 24th, 2002, 04:17 AM

Try this thread

http://www.mrexcel.com/board/viewtop...rum=2&start=20

or this:

http://www.mrexcel.com/board/viewtop...c=3139&forum=2

[ This Message was edited by: Brian from Maui on 2002-03-24 03:21 ]

breenio · Mar 24th, 2002, 04:23 AM

I will have a go

Ta

Dave Hawley · Mar 24th, 2002, 04:23 AM

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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 04:13 AM	#1
breenio New Member Join Date: Mar 2002 Posts: 2	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

Mar 24th, 2002, 04:17 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try this thread http://www.mrexcel.com/board/viewtop...rum=2&start=20 or this: http://www.mrexcel.com/board/viewtop...c=3139&forum=2 [ This Message was edited by: Brian from Maui on 2002-03-24 03:21 ]

Mar 24th, 2002, 04:23 AM	#3
breenio New Member Join Date: Mar 2002 Posts: 2	I will have a go Ta

Mar 24th, 2002, 04:23 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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]