Calculate value of date and time difference

HI,

I have watched and executed all the guides and tips from all the VBA and you tube tutorials.
Unfortunately, my formulas still don't work.

I have 3 columns:
Time start (A1), Time end (B1) and Difference of time (C1)
My formulas are as follows:
A2 2014/03/03 08:11:01 AM
B2 2014/03/03 01:00:50 PM
C2 =B2-A2 (format: custom/(h):mm:ss

I have chosen every single formatting option for columns A and B but still get the error #VALUE in C2.

PLEASE CAN YOU ASSIST!

Thank you.

However, where is the link to attach the file - please?

Thank you.

Please refer to attached.

Kind regards,

Hi,
Unfortunately, its not working. What format does columns A and B need to be in? Text formatting?
What about Column C (currently custom/(h):mm:ss?

Thank you, when I open the file I can see the calculated time - however it is in protected view. The moment I select enable editing, it gives me the #VALUE errors again.

I have even tried the following, which seems to have worked for another user:

1. Highlighted the date and time column;
2. Selected Data in the menu across the top;
3. Chose "text to columns" option;
4. Clicked on "finish"
5. Highlighted my time column and chose formatting as "mm:ss.00"
6. In my time difference column I chose the formatting as "(h):mm:ss
7. I also looked at my regional settings and ensured that I chose the English (UK) option.

Nothing seems to work.

Hi Legal_Consult

You have a space preceding the values of the from and to dates. Use a Trim formula to remove the spaces and then your simple deduction of end time - start time will work.

Cheers

Thank you Marais, I will try it.

Thank you MaraisV and nflsales,

I have now managed to get it right. My problem was the spaces before the dates.

Regards,