Link to home
Start Free TrialLog in
Avatar of Escanaba
EscanabaFlag for United States of America

asked on

Excel 2007 Formula to Convert Military to Standard Time

Hello,

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).

Thanks!
Avatar of byundt
byundt
Flag of United States of America image

Try a formula like:
=C2            format the results using the Time format
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial