Ask Your Question
0

how to convert a number into minutes? [closed]

asked 2012-11-18 13:26:15 +0200

ROSt52 gravatar image

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 flag offensive 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

3 Answers

Sort by » oldest newest most voted
0

answered 2012-11-18 14:03:23 +0200

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.

edit flag offensive delete link more
1

answered 2012-11-18 16:56:44 +0200

updated 2012-11-18 16:58:13 +0200

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/1440
edit flag offensive delete link more
0

answered 2012-11-19 02:08:26 +0200

ROSt52 gravatar image

updated 2013-03-27 15:49:16 +0200

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2012-11-18 13:26:15 +0200

Seen: 20,409 times

Last updated: Mar 27 '13