![]() ![]() But I want the output to be $Īctually my case is that the times are what I used as an example, but the output should be mL based on say 250mL/hour and I want to know how many mL over the number of minutes duration (the durations are from say 20 minutes to 2 hours). G$1 * (A13−A12)/60 I get 8m 3s, so the output unit is apparently minutes. G$1 * (A13−A12) = 483 m 20 s (I did use 20, but the time span is 20% different, but the answer should be around $7 Easy math, but how do I do it in Numbers? Some trials: Using for example A12−A11 results in an answer I can format.īut I want to for example come up with G$1*(A12−A11) where G$1 might be dollars per hour I want to know how much the time was worth. Numbers allows you to format the visible. I want to do some further math and need to know or control the units. Units of time difference between two (calendar) times in Numbers One can take the difference between two datetimes and the default come as x hrs x minutes xx second (at least using datetimes within few days of each other. For direct entry of durations, always use the less ambiguous 5h 45m 33s style.įor your case, where the durations are being calculated from a number representing hours and fraction of an hour, none of these display formats should cause issues. I do NOT recommend the 00:00 setting if you are entering duration values directly, as Numbers will often mis-recognize such an entry as a time-of-day part of a date&time value, rather than a duration, or will misinterpret the units to be applied to each part. This can be shortened by removing the unused tokens, but NOT the commas marking where each unit would fit in the formula: The formula in B2 of the table (and in all the rest, differing only in the row part of the A2 cell reference) is shown below:ī2: DURATION(weeks,days,A2,minutes,seconds,milliseconds) The third example uses the same Duration and Units settings as the second, but adds a Style setting to display as 0:00. the display is automatically rounded to the nearest minute, but the actual value contained in the cell keeps the extra seconds. The second example has cells B5 and B6 set to Duration, with custom units set to display only hours and minutes. The first leaves cells B2 and B3 set to Automatic, with the units also left at automatic. ![]() When I input 10.4 into cell A1, what formula do I type in cell B1 to return the value of 10:24 as displayed?Īlso, if my recorded drive time is 10.69 (A2), will this same formula return a value that rounds to 10:41 (B2), assuming the calculated value of 10:414 rounds down or up to two places automatically? One minute off either way doesn't matter, but if I share this file I want others to use it without being confused and trying to convert two digit decimals to minutes. In this example I would like 10.4 (cell A1) to display as 10:24 (cell B1). My objective is to add a column and use a formula that displays a meaningful value my mind can relate to. For example, 10:24 minutes of driving time displays as 10.4 hours. I transpose my driving time from an on board recording device that displays the hours driven in decimal format. As a driver subject to the DOT 70 hour clock I record and monitor my driving activity and store it in iCloud so I always know if I have enough driving time to accept a load. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |