set time
Hi,
=IF(Processtype@row = "Fast", Starttime@row + 30, IF(Processtype@row = "Long", Starttime@row + 60, IF(Processtype@row = "Large", Starttime@row + 120, "Not Proper process Type")))
Actually i would like to do, if procees type Fast ,, add 30 min more with starttime, Long means 1 hr,Large means 2 hr,,
can anyone pls help me to fix the problem...
Thank you for your help,
Answers
-
It thinks 08:00 is a text value, so isn’t adding 30 min as you’re expecting. Think this would require using a Date column type for both columns.
-
Hallo Mr. Jason, Thank you for your reply and time,,
i tried to change the column type,, but still same problem ,,,, Is thr any other posiibility
-
There should be a solution tucked away in this thread:
-
hi @Paul Newcome i have searched on that link but am not sure how to bind up that in my solution,,
can you please help me..
-
There should be a solution there regarding (if I remember correctly) shifts that account for a "lunch break". That would be the base of the solution.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!