Outputting time correctly when using IF statements

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
661
Hi,
i might me missing something simple here but i have the following:

Code:
=IF($A1="Day1","08:00:00",IF($A1="Day2","09:00:00",0))
Now this outputs as strings which makes it difficult to use in calculations
How can i output the 08:00:00 and 09:00:00 as proper time values ?

Thanks
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,089,745
Messages
5,410,183
Members
403,302
Latest member
Richard Genet

This Week's Hot Topics

Top