Formula to calculate duration between 2 datetime columns

We want to create a very basic calculation in Monday.com which gives us the difference in hours between 2 datetimes. I know that this could be done with the time column but that could not calculate the time difference if it spans on 2 days (eg, Start - 30/08/2022 15:00 End - 31/08/2022 02:00)

I think this should be included in the formula column .

@MikaelZarb

Try this:
DAYS({End}, {Start}) * 24


Jim - The Monday Man
**:magic_wand: Column Magic :sparkles: **- the magical columns toolbox app
What is Make & How can it help you with monday?

2 Likes

Thanks for Sharing. it worked perfectly :smile:

I’ve been trying to search the internet for weeks and couldn’t find anything that works.

1 Like

@MikaelZarb

You’re welcome. I’m glad it worked for you!


Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app
What is Make & How can it help you with monday?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.