Hi list, I'm preparing a scenario of an event, and I'd like to have a table like this:
| Time | Duration | What happens | | | (minutes) | | |-------+-----------+--------------| | 10:00 | 10 | ... | | 10:10 | 2 | | | 10:12 | 5 | | | 10:17 | | | Is it possible to devise some smart formula to put into column one, so that I only have to fill in the "Duration" column? I skimmed through the Calc manual, but didn't found much about displaying HMS forms /without seconds/. TIA, -- Marcin Borkowski http://octd.wmi.amu.edu.pl/en/Marcin_Borkowski Adam Mickiewicz University