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.
 
Back
Top