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

R

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value converted to hours and mins? 2
Convert minutes to hours and mins 5
how can i convert a value quoted in hrs,mins,secs to just mins 1
Custom Formatting: 5.23 into 5 hrs. 14 mins. 3
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
How do I convert hours and mins into just minutes in excel? 1
how do i find # hrs & mins. between 2 different dates and times 3
to convert Minutes into Day:Hr:min (not as fraction) 2

Top