Please find the attached file, facing issue to calculating the late hours if hours are exceeding from 24. Less than 24 hours formula result is perfect.
As I am rookie, May be I am wrong...
what we want is sum total of hours, ex., 25:01:00 instead of 01:01:00,
please try with change in Format Cell(Time) (ex., 37:55:00 )...
I am also waiting for experts reply.
Right click your cell - Format Cells - Number Tab - Select Custom - Type: scroll down to and select [h]:mm:ss - OK
If you don't need the seconds just enter manually [h]:mm in the Type bar
(BTW using merged cells for your dates is a bad idea and will get you into trouble for further analysis)
Also your formula can be shortened to