JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
i might me missing something simple here but i have the following:
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
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