|I created a new column in excel to give a time difference between each case that is billed and shows time difference in hh:mm.|
A caution, if your time calculations cross over midnight you may experience some problems.
I'm guessing that your formula in Column D is somthing like: =B3-B2
With DerbyDad03s formula in E3
Your data looks like:
A B C D E
1) Case Nbr Billed Time Employee. Differnece
2) 001 23:58:00
3) 002 0:05:00 -0.995138889 #NUM! < Formula
You will notice that the time difference is expressed as a negative number, which will force DerbyDad03s formula to error out with a #NUM! error.
The simple correction is to add a date to your Billed Time.