Combining Times and digits

[hcj]

Hi b,
Excel stores time in decimal days. If call timestart
is truly time, then divide the call length in minutes by
1440 and add to timestart. Dividing converts the minutes
to decimal days. Format the result cell to the time
format needed.
Subtracting two times will give a delta in decimal
days. Multiply the delta by 1440 to get delta in minutes.

hope this helps

-----Original Message-----
I have a nightmare project on my hands. I work for a

large company that makes thousands of calls per month from
hundreds of phone numbers. We randomly discovered that
our telecom company is charging us for bogus calls. My
job is to go through large spreadsheets of calls and
determine which ones are bogus.

The spreadsheet has a few columns, but here are examples of the important ones:

Date Time of Call Length of Call
9/15/2003 16:48 5.42
9/15/2003 16:50 3.71

Length of call is minutes, but written like shown.

If this is one phone number, you can see that the second

phone call was made while the first call was still
ongoing. Simply impossible! But we've been billed like
this, and my job is to find out how long it's been going
on, how much we've been overbilled, and to get a refund.

Since I am dealing with hundreds of thousands of entries,

I was hoping to use functions to do some simple
calculations instead of manually searching everything. If
you simply add Time and Length, you get something crazy.
I can't seem to convert the length to time format - it
switches the date, not the time.

I tried using the minute(), time(), and similar

functions, but to no avail. The two columns simply won't
add up. I was hoping to add the length of the call to the
time of call, and compare to the time the next call was
made. If they overlap, I know there is a problem.

I don't know anything about macros, and would have to

hire someone on a non-existent budget to code macros.