Outputting time correctly when using IF statements

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
609
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
 

Forum statistics

Threads
1,078,366
Messages
5,339,769
Members
399,323
Latest member
letitiaysk

Some videos you may like

This Week's Hot Topics

Top