Time into hours where days are counted

[Brawlstrogg]

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 solution]

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 :)

[Brawlstrogg]

Hey @LordNeilLord - I've figured it out in a different format (Text to columns and *'ing everything into oblivion)

Thanks for your help, both ways work mind!

Curse the common cold and it's ability to destroy logical thought.

B