Time into hours where days are counted

Question

Morning all,

I've got a dataset that has decided that anything over 24 hours should count as a day, so it's appearing like the following;

1900-01-04 16:07:12

normally on Excel you can get around this with the old [h]:mm:ss and then maths based on that, but I need to make that original format (Date-Time) become a total of seconds for the record.

I've tried the formula "DateTimeDiff('1900-01-01 ' + [Date-Time Example],'1900-01-01',"seconds")" - but I just get a null value.

Any help would be appreciated muchly.

B.

LordNeilLord · Accepted Answer

Morning @Brawlstrogg,

I'm not sure I entirely understand what you're after....but here's how I interpreted it:

If that's not what you needed....attach an example in excel and we'll figure it out :)