Hi Beth,
Beth wrote:
is there a function to convert regular time entered into cell into
military time?
It depends on what you're trying to do. If you need the military time as a
string (text), you could do this:
=TEXT(A1,"hh:mm:ss")
If you just need a cell that contains a time entered as 8:30 PM to display
20:30:00, you can simply format the cell:
1) Select the cell, right click, choose Format Cells...
2) Select "Time" from the listbox on the left, then choose the format
that looks like Military Time (3rd from last on my machine)
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]