S
Support
I have a cell format of dd-mm-yyyy hh:mm that I have applied to "call open
date and time" and a "call closed data and time" columns.
I'd like to have a further column that calculates the difference in days and
hours, or just hours, between these two date/time values.
I can't seem to find a way to do it tho.
I have tried DATEDIF but it doesn't give me the results I want (formula
=DATEDIF(A1,B1,"d")) and I have seen examples of calculating the difference
between time values but again, not what I want exactly.
Is there a way to do this or do I have to split the cells so I have date in
one cell and time in another?
Many thanks
date and time" and a "call closed data and time" columns.
I'd like to have a further column that calculates the difference in days and
hours, or just hours, between these two date/time values.
I can't seem to find a way to do it tho.
I have tried DATEDIF but it doesn't give me the results I want (formula
=DATEDIF(A1,B1,"d")) and I have seen examples of calculating the difference
between time values but again, not what I want exactly.
Is there a way to do this or do I have to split the cells so I have date in
one cell and time in another?
Many thanks