Difference between millitary date/time in standard time

[karic]

I need to cacluate the difference between a start date/time and an end date/time. The time is in millitary time but I need the end result to be in hh:mm.

[MMcCarthy]

OK the Hour function will give the hour difference between two dates, the Minute function will give the number of minutes and the Text function will allow you to format the date in hh:mm format. So assuming the start date/time is in cell A1 and the end date/time is in cell B1 then the formula will be as follows.

=TEXT(HOUR(B1-A1) & ":"  & MINUTE(B1-A1),"hh:mm")