I have in
cell a1 time information (format HH:MM)
cell b1 a figures representing minutes
I want to add the time information and the minutes into cell c1.
a1: 13:30
b1: 10
c1: 13:40
I don’t want to enter the minutes in b1 as HH:MM, but only as a number.
Thanks in advance for the hint on how to convert the number into minutes format.
As moggi pointed out, time in Calc is just number. In fact, integers count as days (since 30 December 1899), while fractions count as part of days. So, to answer your question, you might ask yourself: how big portion of day is 10 minutes?
There are 24 hours in a day, each hour has 60 minutes; there are 1440 minutes in a day. So, one minute is 1/1440, or 1/(24*60), which is exactly 0,00069(4). But since you have more than just one minute, you must multiply that fraction by number of minutes (B1 value). This is B1*1/1440, or simply B1/1440.
So, your formula might be:
=A1+B1/1440Hey,
TIME(0,$B$1,0) will give you a time value based on the minutes in B1.
Keep in mind that dates and time in calc are just numbers with special formatting. 10 minutes for example is around 0.006944.
You find some more date and time functions in the function wizard.
Thanks for both answers. Both are very helpful. Problem is solved.
I had a look at the Calc manual and help file for TIME and did not find the information you gave me. I suggest that both your answers to be included in the manual and help file. The help file shows 2 examples for TIME but not an examples with a reference to a cell. I misunderstood the help file others might do it as well. Thus I hope both examples will soon appear in the manual and help file.