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)
In general it works
Perhaps you have text somewhere. Better if you could provide simple sample file to check.
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.- Hello Sergei,
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)
Thank you for the file. Excel doesn't recognize @10:46 in, thus an error
=IF(B7=0," ",D7*@10:46)You may use
=IF(B7=0," ",D7*"10:46") or more reliable =IF(B8=0," ",D8*TIME(11,47,0))SergeiBaklanI am trying to do something similar. I want to calculate the total time to assemble
19 pcs * :45 minutes each unit
How do I get it to display correctly?
Windows 11 Pro
Version 22H2
Office 365
Version 2307 Build16626.20170
