9 дек. 2014 г. · I'm trying to convert time to seconds, multiply it by 1.29, and then convert the seconds back into time. If there was a way to multiply time ...

19 мар. 2021 г. · Hi Looking for some help, please. So I am after working out 3 x 4:00. So it is the number 3 (Not time) by 4 hours which is in time format.

22 апр. 2019 г. · Try changing the cell format to: Code: [h]:mm:ss if you want total hours, minutes, seconds. It is important to understand how Excel stores date anf time.

17 июн. 2015 г. · My first step is to figure out how to multiply a date value to return a numeric value since a date is not a technically a number.

6 сент. 2021 г. · I am trying to write formula which will give me the result of 37.5 hours in G3. My Formula which is incorrect shows =(I3-H3-J3)*K3.

22 сент. 2008 г. · I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be.

15 июн. 2011 г. · I need to calculate start times for an event, the event starts and each entry will take 2.5 minutes, I need to calculate when the next entry starts.

5 февр. 2021 г. · I have formatted column B as Custom "dd" and when I multiply with numbers in column C it is not giving perfect result. My expected result is

16 февр. 2012 г. · For example I use =IF(B2<A2,B2+1,B2)-A2 to get the correct number of hours worked for night shifts in C2. Can I then refer to B2 being less than ...

14 мая 2020 г. · I want to x by 24 to give me hours in another column, if i simply type =R2*24 in the next cell it works great but in VBA i get a type mismatch.