How to convert numeric value to mins and addimg mins to Hrs.

[ramana]

Hi everybody,

I need to convert a numeric value to mins(say 2,5 should be
0:02:30.0 which is hrs:mins:sec.decimal) and adding of mins to the
time(say 8:00+0:02:30.0=8:02:30.0) I tried to convert numeric value to
mins in many ways by formatting the cell in different time formats but
I'm getting error. Can any body help me to solve this problem.

Thanks and Regards

Ramana

[Niek Otten]

In Excel, time is stored as a fraction of a day.
So: =A1/24/60 , format as Time. Now you can add to hours.

--
Kind regards,

Niek Otten

"ramana" <ramana_excel@yahoo.com> wrote in message
news:1130491144.713374.250150@z14g2000cwz.googlegroups.com...
> Hi everybody,
>
> I need to convert a numeric value to mins(say 2,5 should be
> 0:02:30.0 which is hrs:mins:sec.decimal) and adding of mins to the
> time(say 8:00+0:02:30.0=8:02:30.0) I tried to convert numeric value to
> mins in many ways by formatting the cell in different time formats but
> I'm getting error. Can any body help me to solve this problem.
>
> Thanks and Regards
>
> Ramana
>