If Blank return no value

Greg Zinn

How would I eliminate the #INVALID VALUE entry when the Start Time is BLANK? Thanks for your help! Here is the formula below. It converts time to Military time.

=VALUE((VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) - IF(VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) = 12, 12, 0) + IF(RIGHT([Start Time]@row, 2) = "pm", 12, 0)) + MID([Start Time]@row, FIND(":", [Start Time]@row) + 1, 2))

Thank you.

Greg

L_123

iferror(formula,"")

=iferror(VALUE((VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) - IF(VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) = 12, 12, 0) + IF(RIGHT([Start Time]@row, 2) = "pm", 12, 0)) + MID([Start Time]@row, FIND(":", [Start Time]@row) + 1, 2)),"")

L_123

iferror(formula,"")

=iferror(VALUE((VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) - IF(VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) = 12, 12, 0) + IF(RIGHT([Start Time]@row, 2) = "pm", 12, 0)) + MID([Start Time]@row, FIND(":", [Start Time]@row) + 1, 2)),"")

Greg Zinn

Thank you!!! :)