Differences between schedules

Hello everyone.
I need to enter two times manually and then draw the difference in a third field.

I point out that I would not use the Time Tracking feature.

I tried among the available formulas but I didn’t find anything that could solve my problem …

Thanks! :slight_smile:

1 Like

I need to enter two times manually

Have you got any sample data?

e.g. 5:00pm less 9:00am?

Yes.

Example: Marketing from 8.30 AM to 10.00 AM.
I need a field that calculates the time elapsed between the two hours entered.

Hey @AleRun

What column type do you use for the times?

Hi @Julia-monday.com,
I use two “Hour” column.

com_boards_319675184

Hey @AleRun

The formula column should support the hour column.

Can you please send me a screenshot of the formula you tried to use?

Honestly, I couldn’t identify the Formula to use to make the difference between two different hours.

Would you be so kind as to tell me? :slight_smile:

Sure!

Can you try this?
32 39

Unfortunately it doesn’t work for me!
Why???

Screenshot_2019-09-19_15_20_39

Weird! Can you drop us a line on email (support@monday.com) so we can investigate further?

Sure! :slight_smile:

Hi - wondering if this will work with Date columns? Trying to keep track of late payments and the number of days late using this formula: ({Paid On}-{Due Date}) and it doesn’t seem to work?

Hey there Matt,

Yes, It definitely works with the date column, but you will have to build the formula another way.

How about using: DAYS({Paid On},{Due Date})

Let us know if you run into any issues! We also have a webinar on how to build formula’s! - Check it out here - monday.com/webinars/

1 Like