Using military time


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?
 
Ad

Advertisements

A

Andy B

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.
 
Ad

Advertisements

S

soccerstr1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Military Time 4
military time 9
Military Time 2
Military Time 1
Military time 6
Military time trouble 7
converting military time 6
time calculation with military time 8

Top