Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula required
I need to get the total hours by multiplying number of staff by number of
hours./mins. Inputting 30 minutes gives me incorrect restlts ie three staff multiplied by 30 minutes results in 90 minutes this should be 1hr and 30 mins help please |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula required
If you have entered the 30 minutes as a number of minutes, rather than as a
time, and you want to show the resulting number 90 as a time, then use =A1/(24*60) and format as [h]:mm -- David Biddulph "Trevor" wrote in message ... I need to get the total hours by multiplying number of staff by number of hours./mins. Inputting 30 minutes gives me incorrect restlts ie three staff multiplied by 30 minutes results in 90 minutes this should be 1hr and 30 mins help please |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula required
Just change the format from
[m] to hh:mm -- Gary''s Student - gsnu200743 "Trevor" wrote: I need to get the total hours by multiplying number of staff by number of hours./mins. Inputting 30 minutes gives me incorrect restlts ie three staff multiplied by 30 minutes results in 90 minutes this should be 1hr and 30 mins help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula help required!!! | Excel Worksheet Functions | |||
Formula Required | Excel Worksheet Functions | |||
A Formula required - please! | Excel Discussion (Misc queries) | |||
Help Required With IF AND Formula | Excel Worksheet Functions |