How to Convert Military Time to Regular Time in Excel Spreadsheet

Learn how to convert military time to standard time in Excel by using this formula: =time(int(a1/100),mod(a1,100),0). Very helpful when needing to manually enter a lot of time values.

[TexasHealthcareAdmin]

This works: [=TIME(INT(A1/100), MOD(A1, 100), 0)] ||| This Didn't [ =TIMEVALUE(LEFT(A1, 2)&":"&MID(A1, 3, 2)&":"&RIGHT(A1, 2)) ] ||| Thank you for sharing.

[JonesRavens]

Worked perfect for me... Just make sure that you have the correct cell name in the formula.

[jenismcmillan]

The military time in my spreadsheet is only display as "19" for for 7:00 PM or "8" for 8:00 AM. There are not minutes included.

[jimira]

How does it work if seconds are included? Ex: 172513 I need this to 5:25:13 PM

[ramtuff]

This only works if your military time is directly typed into the excel spreadsheet. It does not work if its a part of a formula.

[burdine.]

14:30 equals what standard time? Your formula doesn't work for that.

[betenu]

I tried this but it didn't work when the military time was over 50

[tamduong]

I think the movie is the best way for me to learn

[stevensonnwokenkwo]

what about the reverse, and then the video will be complete.

[tjwash]

Please, since we can't see your keyboard, say every thing you are entering as you enter it. Only computer challenged people go to these videos, and it didn't help me, just too fast and missing info I need. Please consider a new video that treats viewer as having never looked at a computer before, because that's practically my skill level.