How Do I Get The Difference In Hours and Mins

M

medicom06

Hi Ian

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
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-


-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top