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
|