Using military time

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

 

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

 

[JE McGimpsey]

For an alternative, see

http://cpearson.com/excel/DateTimeEntry.htm

 

[Gord Dibben]

CB

See Chip Pearson's Quick Time Entry code.

http://www.cpearson.com/excel/DateTimeEntry.htm

Gord Dibben Excel MVP

 

[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