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

  • Thread starter Thread starter ramana
  • Start date Start date
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
 
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

Access Convert a decimal time to hours and minutes 2
how can i convert a value quoted in hrs,mins,secs to just mins 1
Format Cells for Mins / Secs 2
convert 8 hours and 45 min in to 8.75 hours. 1
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
How to enter start and end date/time in excel based on some specific value. 7
How do I convert hours and mins into just minutes in excel? 1
SUMIF using value from MOD function 2

Back
Top