work sheet data -Help to Fix the $formula$

[zah]

Hi guys.. This is critical.. please help me.

i've 2 worksheets..
1st worksheet s like dis..[it has 3 fields]

NAME[1st field]HOURS[2nd field]MINS[3rd Field]
ravi -------------- 5----------------- 50
raju ------------- 4----------------- 30
ravi ---------------2----------------- 20
rahman-----------23--------------------40
raju---------------2---------------------65
suresh-----------4---------------------10

2nd Sheet[has 2 fields]
NAME[1st field]TOTAL TIME[2nd field]
ravi--------------
raju-------------
rahman---------
suresh----------

Now wat i want is<br> The time from sheet 1 [for example RAVI's total time s
8Hrs and 10mins] shud b calculated and put n sheet 2 for respective names

The o/p must b like dis n sheet 2

NAME[1st field]TOTAL TIME[2nd field]
ravi--------------8.10
raju-------------7.35
rahman---------23.40
suresh----------4.10

So.. i have a formula which does the above

B2-->
=TEXT(TIME(SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!B:B),SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!C:C),),"h.mm")

this will give answer as 8.10

THE PROBLEM IS :
If an employee has worked for 24 hours and 30 mins the output shud b shown as
24.30
But
If we use d above formula its showing d output as 00.30.

I have tried INT/SUM and all possible one.. but can't fix this formula.
PLS HELPPPPPPPPPPPPPPPPPPPPPPPPPPP

[DonkeyOte]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests, if you are unclear about their request or instruction then send a private message to them asking for help.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.