Hi Tom,

Two steps: 1) Enter time with a colon separating the hours and minutes
(18:00 or 4:00), and 2) Format the cells in military time {Press Ctrl 1 or go
to the Format Menu - Cells - Number tab - Time [select the military format
you want (ex: 13:00) - press OK]}. Hope this helps.

"Tom" wrote:

How can I caculate military times such as 1800 hours to 400 hours for a time
sheet?