Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Format A1 as time / hrs:mins. Enter 04:35 in A1 - it's the amount of time someone works. Format B1 as currency. Enter $10 in B1 - the workers hourly rate. Format C1 as Currency. In C1, multiply A1 by B1 - and the answer is clearly wrong. It doesn't work because I'm multiplying hours & mins by a decimal. But how do I get this to work correctly? Hope someone can provide a simply answer for a newbie to Excel! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
how to add hours and show actual hours not decimal numbers | New Users to Excel | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |