Can't do multiplication for total hours??

[rayted]

Hi guys,

Can anyone assist with the formula for my 3rd table in the spreadsheet attached? I want to know how many hours are worked in a week (so daily hours worked by the call centre x 7)

Thank you!

[AlKey]

Try this

Please Login or Register  to view this content.

[xlnitwit]

Hi,

The formula should be
=(B24-B23)*7
and then format the cell as
[h]:mm
to see hours over 24.

[rayted]

Hi Alkey,

The format did not appear very clear in the post. I already have this formula, and it is not working?

I need 4 1/2 * 7, but I need this to be in a formula i.e. (time worked to time worked = 4 1/2 hours) * 7.....

[rayted]

Hi there,

The format did not work? I still have ############################???

[AlKey]

Everything works fine.
See attached file

[xlnitwit]

The formula you have is not the same. You have
=B24-B23*7
which is not at all the same as
=(B24-B23)*7

[rayted]

Sadly this did not return a correct value. Thanks for the effort though

[rayted]

Thanks xlnitwit, my poor attention to detail there. You have cracked the problem! Thank you!