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