Multiply by cell contents formatted as hh:mm

  hastelloy 10:26 09 Jun 08
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 08
Answer

Format column E as Number. In E1

=C1*24*D1

  hastelloy 10:45 09 Jun 08

VoG to the rescue once again - many thanks.

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos