Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculating with a time format cell
Hi,
I wana calculate the monthly wages,then in one cell I have hourly wage and in other cell I have total work hour for example (120:45:40),and I want multiple this two cells. How can I convert or change the time cell to a number and write a formula for multipling them? Thank you so much. -------- Regards Mahnaz |
#2
|
|||
|
|||
Hi
if this really is a time formatted cell - then the contents are already a number, just formated to show time. In Excel (and lots of other places) 1 = 1 day so 1/24 is = 1 hour. So you should be able to simply divide your value by 24 then multiply by hourly rate. ttfn benm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |