Formula to calculate military time into hrs
Thanks, I really appreciate the help
Ron
805-529-8300
"Toppers" wrote:
Ron,
A1=23:00, B1=00:15 then in C1 (all entered with format hh:mm):-
=(B1-A1)+(B1<A1)*24
HTH
"Ron - Matrix Investigations" wrote:
ie; 2300-0015 1.5 hrs
|