Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

[wallerjc]

I have two columns, one is formatted as a date with time dd/mm/yyyy hh:mm:ss

e.g. 02/01/2017 14:00:00

and i have another column formatted as hh:mm like so

00:10

How would I remove 10 minutes, from the 14:00 time in the other column?

I've tried Interval with no luck, and simply taking them doesn't seem to work so thought I'd come to the community for advise.

Thanks

James.

[pathiqvd]

Hi,

May be like this,

=date(date(date#('02/01/2017 14:00','DD/MM/YYYY hh:mm'),'hh:mm')-date(date#('10:00','hh:mm'),'hh:mm'),'hh:mm')

Op like:- 14:00 - 10:00 =04:00

Regards,

[antoniotiman · Accepted solution]

Hi James,

try like this

=Timestamp(Timestamp#('02/01/2017 14:00','DD/MM/YYYY hh:mm')-Time('10:00'))

Regards,

Antonio