ExcelBanter - Calculation involving Time format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calculation involving Time format (https://www.excelbanter.com/excel-programming/290385-re-calculation-involving-time-format.html)

Frank Kabel

Calculation involving Time format

Hi chuck
try
e1*d1*c1*24

Frank

Chuck wrote:
Hi Guys

A1=01/01/04 9:00(Format dd/mm/yy 00:00:00)
B1=01/01/04 10:00 (Format dd/mm/yy 00:00:00)
C1 =B1-A1 (Format 00:00:00)
D1=1.50 (Format $0.00)
E1=50 (Format 0.00)
F1=e1*d1*c1 Should be $75.00 but Im getting $3.12

How do I make it work?

Thanks in advance
Chuck

Chuck[_9_]

Calculation involving Time format

Duh!!!!
Thanks!

All times are GMT +1. The time now is 09:21 PM.