Converting hh:mm and mm:ss to Military Time

  • Thread starter Thread starter Jeff Keel
  • Start date Start date
J

Jeff Keel

I'm trying to convert a time format into military time,
for example, if I enter "3:23" (3 hours 23 minutes), what
formula would I use to make another cell display "3.38"?
Also, would the same formula work for mm:ss.

Thanks,
Jeff
 
Jeff
For information on how Excel deals with times check out Chip Pearson's site

http://www.cpearson.com/excel/datetime.htm#WorkHour

Good Luck
Mark Graesse
(e-mail address removed)

----- Jeff Keel wrote: ----

I'm trying to convert a time format into military time,
for example, if I enter "3:23" (3 hours 23 minutes), what
formula would I use to make another cell display "3.38"?
Also, would the same formula work for mm:ss

Thanks
Jef
 
Back
Top