I am a beginner and wanted to make a few custom changes through formula’s and other customisation’s. I need help with the two doubts below. Also take reference from the two photos.
1. How do I setup the “Hours” formula field such that even if its 10 mins more than a perfect hour it will round it off to 2 hrs and so on for any more amount of time.
2. In the first photo, is it possible for the “End Time” to solely be a time field Instead of Date and Time.
Would be really helpful I could get some solid advice on this!
Round Off the Time Duration to the the next higher hour no.
+31re: 1. How do I setup the “Hours” formula field such that even if its 10 mins more than a perfect hour it will round it off to 2 hrs and so on for any more amount of time.
Try:
ROUNDUP(
DATETIME_DIFF(
End,
Start,
'minutes'
) / 60,
0
) 
---
re: 2. In the first photo, is it possible for the “End Time” to solely be a time field Instead of Date and Time.
You could probably do something crazy with a single line text field that you input the time into (e.g. 13:30), and then use a formula field to help you calculate stuff; might be more trouble than it's worth though
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.