Excel Formula for Time Difference

[SeaLawyer]

I'm trying to subtract the time between two dates but keep getting different #VALUE! errors.

Any help is greatly appreciated.

Thanks so much!

Date Time (Start) Time (End) Duration (H:M)
Thursday, October 22, 2015 10/22/15 13:30 10/22/2015 19:30:00 PM #VALUE!
Saturday, October 24, 2015 10/24/15 10:10 10/24/2015 16:10:00 AM #VALUE!
Saturday, November 07, 2015 11/7/15 19:50 11/8/15 19:50 0:00
Tuesday, November 24, 2015 11/24/15 0:00 11/24/15 0:00
Thursday, December 03, 2015 12/3/15 0:00 12/3/15 0:00 0:00
Tuesday, December 22, 2015 12/22/15 0:00 12/22/15 0:00 0:00

[Richard Buttrey]

Please upload the workbook so that we can see the request in context. It's not easy to determine your layout from the post.

[SeaLawyer]

OK! Here's the sample template (rough draft)...

Thanks so much Richard!!

It's not letting put in an attachment.

[SeaLawyer]

Please upload the workbook so that we can see the request in context. It's not easy to determine your layout from the post.

Sample.xlsx

Trying Again...

[SeaLawyer]

Can anyone help?

[Richard Buttrey]

HI,

Your dates are a complete mixture, First of all they're all strings of text not proper date numbers. Moreover the strings are not consistently formatted which makes string slicing functions in order to create a date number more difficult. For instance sometimes the year is 2 digits and sometime 4. Sometimes there is a PM with the time and sometimes not.

Are you able to get consistent date/time numbers since that makes the solution so much easier?