Using military time

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

We enter a lot of data manually, using the time format
hh:mm, it is cumbersome because of the colon. We would
really prefer to use military time, the problem is we
calulate time differences using the formula '=SUM(C12-
B12)', and the date formatting does not allow for military
time. How do we get around this?
 
Hi

If you format the cells as text first, and enter the time as 1355, you can
use a helper column:
=VALUE(LEFT(A1,2)&":"&RIGHT(A1,2))
to turn this into an Excel-recognised time. Just format the cell as hh:mm

Hope this helps.

Andy.
 
how would this work if you wanted to paste cells into a spreadsheet? i
there a way to have the formating carry over to pasted cells
 
Back
Top