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

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
How do I convert hours and mins into just minutes in excel? 1
Date & Time Convert to Numeric Value 6
How to enter start and end date/time in excel based on some specific value. 7
how do i find # hrs & mins. between 2 different dates and times 3
Time Question 2
converting minutes into hrs mins 3

Top