IkEcht
02-10-2009, 08:43 AM
Hi,
in my workbook I have sixteen pairs of times (hh:mm:ss).
For each pair I need to determine if the first time is smaller then the second time + 30 seconds.
Being quite unfamiliar with the excel time-functions and with the few things I tried not working (if(e4<(f4+time(0;0;30));1;0) for instance), I'm actually just taking numbers out of the cell as if it was a string and do the calculation in vba.
Now there should be better/more simple ways to do this. Can anyone give me a lead? Can be either within vba or just excel, I don't mind.
thanks!
in my workbook I have sixteen pairs of times (hh:mm:ss).
For each pair I need to determine if the first time is smaller then the second time + 30 seconds.
Being quite unfamiliar with the excel time-functions and with the few things I tried not working (if(e4<(f4+time(0;0;30));1;0) for instance), I'm actually just taking numbers out of the cell as if it was a string and do the calculation in vba.
Now there should be better/more simple ways to do this. Can anyone give me a lead? Can be either within vba or just excel, I don't mind.
thanks!