+2Hello,
I am in need of a formula that can calculate a duration of time for payroll for hourly employees. I have a column with Start Time and one with End Time using duration. I also have separate columns for both to capture AM or PM.
I just can’t seem to get the formula correct and getting the correct duration. If I need to change my columns I am up to however it can work. I do have a date column to if that helps with the formula.
Thanks in advance for the help.
+3Hi
You say your start and end times are duration fields. They should be date fields with time enabled. If you are set up that way, then your duration formula will be as follows.
IF(
OR(
{Start} = BLANK(),
{End} = BLANK()
),
BLANK(),
DATETIME_DIFF({End}, {Start}, 'minutes')
)
+2Thanks, but I need my techs to enter or choose a time. This way is a time stamp style and they don’t use this as a check in and check out time while onsite. So this way won’t work. Issue is when you go from say 8am to 3pm it won’t calculate 7 hours.
Thanks again
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
