Hi All
I am wondering if someone could help me please.
Need to calculate date and time difference between three columns.
The problem I'm facing is that, one of the dates and time are in a separate columns (F&G):
Column F=date
Column G=time (of F)
Column K = date & time together (separate column).
At the moment I'm using an helper "M" column to combine both cells (F&G), but if we could avoid helper column it will be great.
File attached for better explanation.
Any help it will be appreciated.
Thanks in advance.
Regards
R
I am wondering if someone could help me please.
Need to calculate date and time difference between three columns.
The problem I'm facing is that, one of the dates and time are in a separate columns (F&G):
Column F=date
Column G=time (of F)
Column K = date & time together (separate column).
At the moment I'm using an helper "M" column to combine both cells (F&G), but if we could avoid helper column it will be great.
File attached for better explanation.
Any help it will be appreciated.
Thanks in advance.
Regards
R