| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying time by number
I want to multiply hours and minutes worked by number of workers. Any suggestions? -- God's Kid ------------------------------------------------------------------------ God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426 View this thread: http://www.excelforum.com/showthread...hreadid=505894 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying time by number
Assuming you are usin hh:mm format and you want to convert the total to hours then if your time is in A1 say 11:28 and your number of employees is in A2. =HOUR(A1)*A2+((MINUTE(A1)*A2)/60) This will return 57.3 hours for 5 employees. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=505894 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying time by number
=A1*B1
FormatCellsNumberCustom, in the Type box, enter [h]:mm -- Kind regards, Niek Otten "God's Kid" wrote in message ... I want to multiply hours and minutes worked by number of workers. Any suggestions? -- God's Kid ------------------------------------------------------------------------ God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426 View this thread: http://www.excelforum.com/showthread...hreadid=505894 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying time by number
Thanks that did the trick SteveG Wrote: Assuming you are usin hh:mm format and you want to convert the total to hours then if your time is in A1 say 11:28 and your number of employees is in A2. =HOUR(A1)*A2+((MINUTE(A1)*A2)/60) This will return 57.3 hours for 5 employees. Does that help? Steve -- God's Kid ------------------------------------------------------------------------ God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426 View this thread: http://www.excelforum.com/showthread...hreadid=505894 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a six figure number to a time. | Excel Discussion (Misc queries) | |||
| Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
| Time functions, how do I work out number of hours | Excel Worksheet Functions | |||
| Converting whole number to TIME | Excel Discussion (Misc queries) | |||
| avoid retype the number more than one time withen acolumn | Excel Discussion (Misc queries) | |||
Linear Mode
