![]() |
#5
|
|||
|
|||
![]()
Hi,
that does it, and I would need that between the actual two times in col A. I didnt realise though that the formulation for calculating the increment between two times in A1 and A6, a 5 cell progression was so 'overwhelming'. I have lots of these time gaps of varying cell gaps and I see copy paste of that formula in C1 works for any gaps now. Is it necessary to have a new column for times, as all cells have to have the formula in I imagine so. I will collapse up column A afterwards, or I could paste value into another column and nuke A and C ! I typed out the long formula with { } and nothing worked, a friend said remove the { } and then go ctrl shift enter, then it worked , after formatting the cells as time. I had hoped Excel would have had a menu choice of even progression between two selected values. Thanks DBenz |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
If a2 is not empty, color empty cells in b2:af2 | turkanet | Excel | 2 | 08-20-2017 11:00 PM |
![]() |
Frantic | Word VBA | 2 | 01-24-2015 04:54 PM |
![]() |
nicholes | Excel | 7 | 12-23-2013 06:27 PM |
How do you loop through an array with some empty values? | omahadivision | Excel Programming | 5 | 11-28-2013 10:49 AM |
Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |