Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time problems
I have a spread sheet and in this sheet i have a set time that it takes to do
a run ie 01:30 1 hour 30 mins (A1) then i have another cell that i input a time (A2) and a 3rd cell that has an if function that says =if( a20, a2-a1,"") this works fine untill the time difference goes back past midnight, if A2 = 01:00 and A1= 01:30 then i get ###### instead of 23:30, in lotus 123 it worked fine but excel seems to have a problem with this, any ideas what i am doing wrong ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
elapsed time problems | Excel Worksheet Functions | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions |