Difference of time in hours or minutes
 

Date (Requested) Time (Requested) Date (Update) Time (Update)
1/9/2006 9:09:50 1/10/2006 13:04:22
1/4/2006 20:50:20 1/17/2006 11:32:00
1/10/2006 2:19:11 1/10/2006 9:29:09
1/16/2006 3:44:36 1/19/2006 17:46:24


I have the following data in an excel sheet in different columns, and i
would like to subtract the Date & time of requested data from Data &
Time of Updated data, with the anwser in hours or minutes.
Can anyone help, i have over 1000 data points to calculate, and i can't
do this by manually.

Thanks,
Charles D.

Difference of time in hours or minutes
 

Hi Charles

Try
=(C1+D1)-(A1+B1)
Format the cell with the formula FormatCellsNumberCustom [h]:mm
and this will allow it to deal with periods greater than 24 hours.

Copy down as appropriate.

--
Regards

Roger Govier


"Charles" wrote in message
oups.com...
Date (Requested) Time (Requested) Date (Update) Time (Update)
1/9/2006 9:09:50 1/10/2006 13:04:22
1/4/2006 20:50:20 1/17/2006 11:32:00
1/10/2006 2:19:11 1/10/2006 9:29:09
1/16/2006 3:44:36 1/19/2006 17:46:24


I have the following data in an excel sheet in different columns, and
i
would like to subtract the Date & time of requested data from Data &
Time of Updated data, with the anwser in hours or minutes.
Can anyone help, i have over 1000 data points to calculate, and i
can't
do this by manually.

Thanks,
Charles D.

Difference of time in hours or minutes
 

Roger Govier wrote:
Hi Charles

Try
=(C1+D1)-(A1+B1)
Format the cell with the formula FormatCellsNumberCustom [h]:mm
and this will allow it to deal with periods greater than 24 hours.

Copy down as appropriate.

--
Regards

Roger Govier


"Charles" wrote in message
oups.com...
Date (Requested) Time (Requested) Date (Update) Time (Update)
1/9/2006 9:09:50 1/10/2006 13:04:22
1/4/2006 20:50:20 1/17/2006 11:32:00
1/10/2006 2:19:11 1/10/2006 9:29:09
1/16/2006 3:44:36 1/19/2006 17:46:24


I have the following data in an excel sheet in different columns, and
i
would like to subtract the Date & time of requested data from Data &
Time of Updated data, with the anwser in hours or minutes.
Can anyone help, i have over 1000 data points to calculate, and i
can't
do this by manually.

Thanks,
Charles D.


Thanks