Hello,

I have a quick question. Seems like it should be very simple and common problem, but I couldn't find the answer elsewhere.

My problem is that I have a dataset, where the elapsed time is in minutes. I also have a start time from which the elapsed time is calculated. I need to regroup this into a single column with the following format: 2010-08-26 11:08:57 (year-month-day hour-min.sec).

To add the minutes I use the TIME(hour;min:sec) function. However, once the minutes exceed 1440 (1 day) Excel resets the minutes and only adds the value above 1440. I understand you can specify [min] in the format to add over a 24h period but in this case I would simply like to take this into account in the date.

Do you have any suggestions?

Many thanks in advance.

Kim