| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate difference (mins) between 2 Times
Hi guys,
Re-table below in cols A to C where its required to calculate the "Diff (mins)" in col C (Col C = Time B - Time A) Times are in text in cols A & B in the form: 0245 hrs, 0315 hrs, etc Time A Time B Diff (mins) 0245 hrs 0315 hrs 30 0705 hrs 0735 hrs 30 1955 hrs 2050 hrs 55 2335 hrs 0005 hrs 30 2355 hrs 0035 hrs 40 etc What can I put in C2, and copy down to return the desired results ? Thanks -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Calculate the difference two times | Excel Discussion (Misc queries) | |||
| Calculate the difference between two times | Excel Worksheet Functions | |||
| How can I calculate the difference between times without using th. | Excel Worksheet Functions | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Threaded Mode
