M
medicom06
Hi Ian
Thanks for all the help. You've indeed been real helpful
Thanks for all the help. You've indeed been real helpful
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
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-
-