re: 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