Junior Member

Posts: 2

How Do I Get The Difference In Hours and Mins

Hi

I'm working in a freight forwarding company. I basically need to know the formula to get the difference in hours and mintues base on the PDF file attached. Please note that the date and time are together in one cell for example A1 (d/mm/yyyy hh:mm). Hope someone can help me with this issue.

Kindly see attached.

A1
31/07/2005 20:15

B1
1/08/2005 08:50

C1
B-A = hh:mm

Thanks in advance!

Cheers
Eugene

Attached Images

Help.pdf (15.5 KB, 60 views)

Last edited by medicom06 : August 11th 05 at 08:02 AM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel [HHHHH]:mm add subtract hours mins inc lnegative	mexico	Excel Worksheet Functions	0	July 5th 05 05:45 PM
Getting a total of hours & mins worked per week	big_weegie	New Users to Excel	1	June 16th 05 11:44 PM
how do I total hours and mins in excel	big_weegie	Excel Worksheet Functions	0	June 16th 05 10:52 PM
Help! I am stuck calculating Days, Hours, Mins please help	OB1	Excel Worksheet Functions	3	November 15th 04 05:17 PM
Help! I am stuck calculating Days, Hours, Mins please help	OB1	Excel Worksheet Functions	2	November 15th 04 05:17 PM

All times are GMT +1. The time now is 11:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us