instruction on how to make a 24 HOUR TIME COLUMN

D

dukeduke

how do i make a column for time read as a 24 hour entry.Example (time)column
in this column i want to type time but in the 24 hour format and have it stay
there in the column
 
P

Peo Sjoblom

So what's your problem? If I type 14:00 in a cell that's what I see.
If you mean what is seen in the formula bar then you need to change the
regional settings of
your OS to 24 hour HH:mm


--


Regards,


Peo Sjoblom
 

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

Adding Days and Hours 8
Converting from 12-hour to 24-hour format 2
Daily Time Sheets with Rounding 1
Hour function equivelent help 3
Timesheets 1
If then request 1
time calculations 1
Countif in a time range 5

Top