troubleshooting Question

Excel 2007 Formula to Convert Military to Standard Time

Avatar of Escanaba
EscanabaFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
2 Comments1 Solution1085 ViewsLast Modified:

Can someone provide a formula that will convert military time to standard.  For example, cell C2 shows 23:27:16 and in cell F2 shows 11:27PM.  Please note:  Some cells in column C will only have minutes (0:22:36) or just seconds (0:00:7).

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros