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 |
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 |
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 |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com