Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)?
My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that would include the number of minutes worked, a Week Total column (to sum the days of the week), and an Updated YTD column (to sum the current YTD to overtime hours worked that week).
Thanks in advance!!
Comments

Hello,
I am new too to Smartsheet, but I have looked a bit into this, and did not find a direct way to do this.
There is a workaround invoving using a pseudodecimal notation for the time, that I will try to describe as follows :
Use notation for 02:15 as 2.15 (like a decimal number). I will call X this notation.
The calculations with time cannot be done directly with 2.15 but in its equivalent in real minutes, which I will call M.
To obtain M, use =ROUND(X) * 60 + 100 * (X  ROUND(X))
After Calculation, to obtain back a notation like X,
use
=INT(M / 60) + (M  60 * INT(M / 60)) / 100
I hope this helps...
Eid

Hi Ed!
Thanks for looking into this. Unfortunately I don't think this will work because I first need to Sum a few time values first. Ex. :15 (*7 days)= 105, which in your formula would think 1.05, which doesn't really align with what I would need it to use (1.45). If you have any other thoughts or workarounds please let me know!
Thanks,
Lindsey

Hello Lindsey,
You would need to convert each of the individual times noted as "h.mm" to real minutes, using the formula above.
Perform the sums with the real minutes, then convert back the result to the h.mm notation using the formulas above.
I hope this helps,
Eid

I could use a time value as well. I need to create an implementation and cutover plan that is down to time values in minutes, not just days, as the cutover will occur over the course of several hours.
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives