number of hours between two date/times
The OP is spoilt. 47 minutes and three alternative solutions. Where else do
you get (free) service like that?
Bob
"Sloth" wrote in message
...
Bob,
you make me look so stupid :). You posted and got a response in the time
it
took me to finish writing my post.
Jason Rackley
"Bob Phillips" wrote:
=INT(A2-A1)&" days "&ROUND(MOD(A2-A1,1)*24,0)&" hours"
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"TBA" wrote in message
...
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-
|