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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,089,220
Messages
5,406,944
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top