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)
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
In Excel datetimes are actually numbers where days are integer part of the number and time is decimal one. One day is equal to 1.
Thus 1 hour = 1/24
1 minute =1/24/60
etc
45 min will be 45/24/60. Multiply on 19, totally =19*45/24/60 and apply time format. It returns 14:15:00.
- Our times are in ":00" format or "0:00". Can I use the following formula where M13=:45 and C13=19
=(M13/24/60)*C13It looks like in M13 you have text which looks like a time, not the time actually (which shall be a number). Could you please check with formulae as
what do they return. If the same what are possible variants for such texts.
It is as you say:
TRUE=ISTEXT(M13)
#VALUE=TIMEVALUE(M13)
I've had some luck with my own formulas if they come back with an even hour. It doesn't like fractions of an hour or minutes.