AleRun
(Alessandro)
September 11, 2019, 7:42am
1
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!
1 Like
JohnW
(John Waller)
September 12, 2019, 4:08am
2
I need to enter two times manually
Have you got any sample data?
e.g. 5:00pm less 9:00am?
AleRun
(Alessandro)
September 12, 2019, 6:34am
3
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?
AleRun
(Alessandro)
September 18, 2019, 1:44pm
5
Hi @Julia-monday.com ,
I use two “Hour” column.
Hey @AleRun
The formula column should support the hour column.
Can you please send me a screenshot of the formula you tried to use?
AleRun
(Alessandro)
September 18, 2019, 2:16pm
7
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?
AleRun
(Alessandro)
September 19, 2019, 1:25pm
9
Unfortunately it doesn’t work for me!
Why???
Weird! Can you drop us a line on email (support@monday.com ) so we can investigate further?
Matt
(Matt Walters)
October 21, 2019, 6:14pm
12
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?
Ben-monday.com
(Ben Feldman ( monday.com))
October 29, 2019, 12:34pm
13
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 - Webinar hub | monday.com
1 Like