Convert Number to Time (decimal)

[rajcobra]

Dear Friends,

I have attendance machine providing working hours in decimal for my employees. But issue comes when I want to add the attendance from two separate machines for same employee in excel.

For Example:

Employee 1
1st Machine - 25.45 (25 hrs 45 mins)
2nd Machine - 1.50 (1 Hr 55 mins)

Total - 26.95
But we need result as - 27.35

How to get this? Request your help...

 

[Ron Coderre]

With this sample data in A1:A3 (I'm assuming you meant the 1.50 to mean 1Hr and 50 Mins)

Mach Hrs
   25.45
    1.50

This regular formula returns the total time formatted as H.MM

A4: =--TEXT(SUMPRODUCT(INT(A2:A3)*60+MOD(A2:A3,1)*100)/1440,"[h].MM")

In that example these are the results:

Mach Hrs
   25.45
    1.50
   27.35

Is that something you can work with?

 

[rajcobra]

Thank you Ron,

Will try this...