Multiply by cell contents formatted as hh:mm

  hastelloy 10:26 09 Jun 2008
Locked
Answered

I have a worksheet where column A is start time, column B is finish time column C is time passed (B-C, if 0)- all formatted as hh:mm. Column D is hourly rate. I need a formula in column E which gives the value (C*D)but which also converts hh:mm format into a number (ie 1:30 to 1.5)before multiplying. Its this last bit that's causing my brain to hurt!!!

  VoG II 10:35 09 Jun 2008
Answer

Format column E as Number. In E1

=C1*24*D1

  hastelloy 10:45 09 Jun 2008

VoG to the rescue once again - many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?