Date & Hrs Sum

Ask for Help
1

Hi,

I am trying to calculate a start date and time from two separated columns but I can’t get it to work with a math column.

image

So the top one should be 27/09/2024:15:00:00

Thanks

2

When you set the configuration of your “Date” column to “Date & Time” and short, you’ll see that there is more to a date column than one might see. A “Date” column type is a timestamp with date and time already included. You would need to take this into account when doing timestamp math.

It could be useful to convert the timestamp to an integer, do math on the integer, then convert that back to a timestamp. The forum is well documented on this approach, @Darren_Murphy covers this often.

3

Thanks, I’ll take a look

4

Yeah… 2 approaches.

  1. combine the two strings with a template column, then use a text to date column to convert to a date.

  2. Subtract the time from the date, then add the time as a fraction of a day. Sometimes you’ll still end up with fractional time since you can’t touch the milliseconds of the datetime value, but it will be pretty close

5

great thanks