Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
103
Views
Topic starter
Hi there,
I need any help.If time is less then 06:00 hrs out put "Need"otherwise "W/H" how to use if function only for hh:mm?
thanks
Posted : 11/04/2017 6:16 pm
Try this
=IF(A1<TIME(6,0,0),"Need","W/H")
Sunny
Posted : 11/04/2017 8:18 pm
Topic starter
Thanks
Posted : 11/04/2017 10:55 pm
