Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Calculation
I am trying to keep race times in excell. Anyway, the question is how to
calculate race results. When I do a simple formula for subtraction, "=A10-A9" kind of thing, the program says that the dates are not compatible. I think the program believes my race time (in minutes) are actually dates, so it has trouble calculating. Any ideas on how to fix this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Calculation
On Sun, 3 May 2009 12:35:11 -0700, Mel wrote:
I am trying to keep race times in excell. Anyway, the question is how to calculate race results. When I do a simple formula for subtraction, "=A10-A9" kind of thing, the program says that the dates are not compatible. I think the program believes my race time (in minutes) are actually dates, so it has trouble calculating. Any ideas on how to fix this? Thanks! Enter the times as times, and not as dates. h:mm:ss.000 --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Calculation
Your formula should work, so it's either your data, or the macro you are
running. What "program" says "the dates are not compatible". It's not Excel, as Excel will happily subtract times, even with dates as part of them. What's in A9 and A10? Regards, Fred. "Mel" wrote in message ... I am trying to keep race times in excell. Anyway, the question is how to calculate race results. When I do a simple formula for subtraction, "=A10-A9" kind of thing, the program says that the dates are not compatible. I think the program believes my race time (in minutes) are actually dates, so it has trouble calculating. Any ideas on how to fix this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
time calculation | Excel Discussion (Misc queries) | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |