Forum Discussion
HOW TO EXTRACT TIME FROM THE FILE IN EXCEL
In this time function column if we drag the cursor on the time format it is not showing the SUM in Taskbar sir. Only the count of the no of rows in the column is shown. I want to have the sum of th...
kiranjab Well, I based the formula on the example data you provided. Try it like this then:
=IF(LEFT(J3,1)="0",VALUE(RIGHT(J3,LEN(J3)-1)),VALUE(J3))
sir,
IN THE GIVEN EXCEL FILE FOR GREATER THAN 100 HOURS COLUMN "J" IS IN TIME FORMAT SO IT IS DIRECTLY CONVERTING IT INTO VALUE USING THE ABOVE FORMULAE. BUT THE GRAND TOTAL IS IS TEXT AND ITS RESULT IS SHOWING AS VALUE ERROR. FOR TIME GREATER THAN 100 HOURS IN TEXT FORMAT THE FORMULA IS NOT WORKING SIR. PLEASE RESOLVE.
IN THE GIVEN EXCEL FILE FOR GREATER THAN 100 HOURS COLUMN "J" IS IN TIME FORMAT SO IT IS DIRECTLY CONVERTING IT INTO VALUE USING THE ABOVE FORMULAE. BUT THE GRAND TOTAL IS IS TEXT AND ITS RESULT IS SHOWING AS VALUE ERROR. FOR TIME GREATER THAN 100 HOURS IN TEXT FORMAT THE FORMULA IS NOT WORKING SIR. PLEASE RESOLVE.