Adding Minutes Into Hours

[callsidd]

Hi All,

Can anyone confirm how to add minutes into hours

Suppose if it is 03:00 PM and i want to add 49 minutes then what is the formula

Please also note, minutes can be vary

regards,

 

[gaz_chops]

One way
A1 = 03:00 pm
Change 49 to be the cell reference containing the value.

=A1+(49/24)/60

e.g.

[/FONT][TABLE="width: 217"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]3:00 p.m.[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]3:49 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]4:00 p.m.[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4:50 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]5:00 p.m.[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]5:51 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]6:00 p.m.[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]6:52 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]7:00 p.m.[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]7:53 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]8:00 p.m.[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]8:54 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 p.m.[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]9:55 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]10:00 p.m.[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]10:56 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]11:00 p.m.[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]11:57 p.m.[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 a.m.[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]12:58 a.m.[/TD]
[/TR]
[TR]
[TD="align: right"]1:00 a.m.[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]1:59 a.m.[/TD]
[/TR]
[TR]
[TD="align: right"]2:00 a.m.[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]3:00 a.m.[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=Lucida Grande]