OVERTIME FORMULA [SOLVED]

[jams]

Dear All,


I have file with the following information please I request some one to advise me how to take total hrs by applying formula in excel

[pre]

Start Time   End Time    Total Hrs
07:00 PM     06:30 AM       11.5
07:00 AM     06:30 AM       23.5 (One day full)

[/pre]
above starting time is in C6 cell and end time is in D6 cell


E6 should be total


appreciate for your kind response.


Regards

Jams

 

[jams]

need your valuble inputs. please comeup....

 

[NARAYANK991]

Hi ,


As far as time is concerned , in Excel it is just a numeric value between 0 and 1.


So if you have two times in C6 and D6 , in E6 if you put in the formula :


=IF(C6<=D6,1+C6-D6,C6-D6)


and format E6 in any convenient Time format , you will get the answer.


Narayan

 

[jams]

Dear Narayan,


thank you very much for ur response, I tried this its working well but i need total hours in numbers at E6 not in time format please advise.


Jams - Khammam

 

[NARAYANK991]

Hi Khammam ,


Sorry ; just multiply the result of the above formula by 24 ; this is because 24 hours equals 1 ( as I mentioned earlier , time goes from 00:00:00 to 23:59:59 , and the numeric value goes from 0 to 0.99999 ).


So the formula will now become :


=IF(C6<=D6,1+C6-D6,C6-D6)*24


Narayan

 

[jams]

thank u boss, i got it and I appreciate for you kind response good bless u.


regards

Jams - AP