Have employees' hours added up

[Scott_N]

I am stumped in how to add hours to a field.

I want to take “Start Time” and add 16 hours. Some example:

Start Time 06:00 result would be 22:00 or 10PM
Start Time 19:00 (7:00PM) result would be 11:00 AM

if I have 14:00 + 16 hours, the answer

Start Time is defined as a Duration - but maybe that is not right.

Thank you in advance to the incredible and generous community minds…

[Ptt_Pch]

I may have something but I needed to add a date, which is kind of logical since if we are the 22/04/18 16h30, when adding 16h, we would be the 23/04/18 8h30.

The {Start time} field is a date field (set on local) which include a time field (in 24h time format without the GMT time zone).

The formula I tried is this one :

DATEADD({Start time},16,'hours')

To which you can apply a formatting so it matches the date and time of the {Start time} field.

It the only thing I could think of, maybe someone with better Airtable skills than mine would do something else :winking_face:

[Scott_N]

Thanks for the help, very much appreciated :slightly_smiling_face:

I have changed “Start Time” to Date and then inserted the formula DATEADD({Start time},16,‘hours’)
Here are the results:

For some unknown reason its off by 2 hours. But it looks like it should work.

[Scott_N]

I got it - my bad :frowning:

I didn’t check the box “use the same time zone for all collaborators”

With that checked - it works perfectly - you are a miracle work :slightly_smiling_face:

[Ptt_Pch]

My bad too :roll_eyes: , I had the same problem when I was testing the formula :grinning_face_with_sweat: and I forgot to mention it in my reply :grinning_face_with_sweat:

But I’m glad to know it finally worked for you :slightly_smiling_face:

[Scott_N]

I am not a coder, so when it comes to tweaks like these it becomes a challenge - I am just thankful for good people like yourself who jump into share.

I am all set now and have it operating as needed - many thanks again for the fast & very helpful support.

[Ptt_Pch]

You’re welcome :slightly_smiling_face: :winking_face: !
I’m really glad it helped :slightly_smiling_face:

(I’m no coder either, I’ve got notions of, but I’m learning how to write my own formulas so when I can help, I gladly do it :grinning_face_with_smiling_eyes: )

[NeilP]

Hello. I’m glad to have found this thread as I am working on a very similar project and I’m hoping you can offer your insights, and formulas!

I’m new here, so please forgive the non-airtable language. :blush:

What I need to create is an itinerary for a bus tour which all happens on the same day and stops at different locations. I would love to create a table which sorta looks like this and makes these calculations:

I’m thinking 2 columns:
Description | time or duration

Departure time | 8AM

Travel time to location A | 20 minutes

Arrival time at location A | adds 20 minutes to 8AM to display 8:20AM

Visiting time at location A | 45 minutes

Departure time | adds the visiting time to the arrival time to display 9:05AM

The tour travels to 5 locations, so I’d repeat that sequence 4 more times. Departure and Arrival times would keep updating as the day progresses.

And we also want a total time traveled at the bottom somewhere which would add all the travel and visiting times up!

So my questions are:
What’s a good way to set this table up?
What type of fields do I use?
What are the formulas I need in the Departure and Arrival times fields?

Once I have one airtable, I plan to duplicate it, so that other tour directors can use my template to plan their day tours!

Thanks in advance and I look forward to hearing from you.
Neil

[NeilP]

Hi Scott. I added a post to your original thread with a further inquiry. In the meantime, another contributor suggested I ask you if you’d be willing to share a copy of your airtable as it sounds very close to what I am working on building.

Would you be willing to share?

[Scott_N]

Mine was very simple and not as complex as what you have outlined, here is the formula I ended with:

DATEADD({Start Time},16,‘hours’)
DATEADD({End Time},-8,‘hours’)

Hope that helps in some small way…