Certain Number of hours multiplied by whole number

[Spud61]

I have a time sheet query

I am trying to multiply together a working length day i.e. 7:24 (this is in the format of hh:mm) with another number indicating number of bank holiday days due to an employee i.e. 11 (this is in general format). I need tha answer in hh:mm format. Is there a formula that will do this?

F31 = 7:24 (hours worked per day) [h]:mm format
K39 = 11 (days bank holiday due) general format
J43 = Hours due in a hh:mm style format

Is there any one that could help?

Deb

 

[barry houdini]

Hello Deb

You can just do a simple multiplication in J43, i.e.

=F31*K39

format J43 as [h]:mm

 

[shyrath]

Try something like this:

=K39*F31

And format as hours