Weekly hours and daily hours not adding up

Hi Team,

Please refer the attached sheet.

The weekly hours and daily hours are not not adding up.

Regards
Shareez

I also want the daily hours to be 24 hours and weekly 48 hours for each staff.

Ignore my second post here if it's a big deal. Please help me to add up the hours.

Impossible to know what the problem is.
The math is being done with a VBA Custom Function.
But the VBA project is password protected, so we can't see it.

I agree with Willem.
You'll be much (and I mean MUCH) better off in the long run by seperating your start and end times into seperate cells.

Can you give the formula in the new sheet?

have a look at this

http://www.excelforum.com/excel-gene...-one-cell.html

Need a formula to add up the time, please refer the attachment in my last post.

See attached: please ensure times are entered in TIME format

Weekly hours?

Try

=SUMIF($D$5:$Q$5,"Out",D6:Q6)-SUMIF($D$5:$Q$5,"In",D6:Q6)

Cell formatted as [hh]:mm

Great Jonmo & John.

Mucha appreciated.

=SUM(D9:Q9) for completeness

You're welcome.