Forum Discussion
Multiply Hours and Minutes by a number
TIME() function requires all 3 parameters, you can't miss seconds. Please check TIME function - Office Support (microsoft.com)
I am using an Acer Aspire 5 laptop running Windows 10 version 20H2, Microsoft Office 2016.
I have setup a spreadsheet to monitor my staff's leave allocation, deduct the appropriate hours and show the balance remaining. As an example please see the following.
Staff member has been allocated 134:26 hours leave. He wishes to take some leave, days between Monday and
Saturday work out at 10hrs 46 mins and a Sunday at 10hrs 18mins. In cell F7 I want to multiply the number of days,
D7 etc, by 10:46 and in cell G8, the numbert of days by 10:18. When I do this I get the #VALUE message.
Finally, the total taken will be deducted from J4 with the balance shown in J22.
Thank you for your response. I used your recommended formula IF(B8=0," ",D8*TIME(11,47,0)) and it worked perfectly. May I ask, why have you set the hours and minutes as 11,47,0? Every example I had seen up to now has recommended that time is shown as 11:47.
Thank you again for your assistance.
TIME() function requires all 3 parameters, you can't miss seconds. Please check TIME function - Office Support (microsoft.com)
- Hello Aergei,
Thank you for explaining that for me. It makes things much clearer and explains why my formula wouldn't work.Baz286 , you are welcome, glad to help