# how to convert a number into minutes? [closed]

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.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-27 13:58:39.963474

Sort by » oldest newest most voted

Hey,

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.

more

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.

=A1+B1/1440

more

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.

more

## Stats

Seen: 22,348 times

Last updated: Mar 27 '13