Excel question - finding difference between dates/times

Mr. Flibble · 2006-03-11 11:24:18

Hi, I'd like to have two columns in excel with the date and time in the format '11.03.2006 11:12:18' (one column) and be able to find the difference in time in mins or hours between the two columns. Can anyone help me? Many thanks.

11-03-2006 12:24PM

#1

Mr. Flibble

Registered Users, Registered Users 2 Posts: 2,364 ✭✭✭

Join Date: October 2000

Posts: 2018

Hi,

I'd like to have two columns in excel with the date and time in the format '11.03.2006 11:12:18' (one column) and be able to find the difference in time in mins or hours between the two columns.

Can anyone help me?

Many thanks.

0

Comments

#2 11-03-2006 04:26PM

subway

Closed Accounts Posts: 6,113 ✭✭✭

Join Date: November 2005

Posts: 5453

first, youll need to custom format the cell to match the date your entering in excel,
your using
dd.mm.yyyy hh:mm:ss
as far as i can see

then use this formula
=TEXT(B1-A1,"hh:mm:ss")

to get the time diff

0
#3 12-03-2006 05:58PM

Mr. Flibble

Registered Users, Registered Users 2 Posts: 2,364 ✭✭✭

Join Date: October 2000

Posts: 2018

Thanks subway

0