G
Guest
I have tried a number of the responses posted- sorry i can't seem to get it
right!
I want to calculate the number of days and hours between two date time values
e.g.
cell A1 start: 17/01/2006 16:12
cell A2 finish: 25/01/2006 10:00
cell A3 answer: 7 days 18 hrs
and is it possible to leave cells A1 and A2 in dd:mm:yy hh:mm format rather
than 'general'?
thanks for your help-
right!
I want to calculate the number of days and hours between two date time values
e.g.
cell A1 start: 17/01/2006 16:12
cell A2 finish: 25/01/2006 10:00
cell A3 answer: 7 days 18 hrs
and is it possible to leave cells A1 and A2 in dd:mm:yy hh:mm format rather
than 'general'?
thanks for your help-