View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron - Matrix Investigations[_2_] Ron - Matrix Investigations[_2_] is offline
external usenet poster
 
Posts: 5
Default 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