The formula could be modified, but it would begin to get ver
cluttered.
Also you would get a 0: display for no days.
An easier way would be to simply subtract the dates and format the cel
as
"d hh:mm". This would work up to 1 month difference only
--
Ian
--
"Scott buckwalter" (e-mail address removed) wrote in
message Can this be extended to [days:]hours:minutes with the days only being
displayed if it's 0?
:
-
There's no attached file.
Assuming the date/time in A1 is earlier than date/time in A2
=INT((A2-A1)*24)&":"&INT((((A2-A1)*24)-INT((A2-A1)*24))*60)
This will return the total hours & minutes between the
values(appearing
as
eg 73:03), but you will not be able to perform any calculations o
it.
--
Ian
--
"medicom06" (e-mail address removed) wrote in message
Hi
I'm working in a freight forwarding company. I basically need t
know
the formula to get the difference in hours and mintues base on th
PDF
file attached. Please note that the date and time are together i
one
cell for example A1 (d/mm/yyyy hh:mm). Hope someone can help me with
this issue.
Kindly see attached.
Thanks in advance!
Cheers
Eugene
+-------------------------------------------------------------------+
|Filename: Help.pdf
|
|Download
http://www.excelbanter.com/attachment.php?attachmentid=24|
+-------------------------------------------------------------------+
--
medicom06-
-
