after midnight subtract How To Subtract Time After Midnight In Excel 09 Mar, 2021 Midnight is always 2400 add an hour for each hour following midnight ie. TIMEVALUE MID LEFT TRIM H2LEN TRIM H2-5FIND L…