SUM of two time columns

FAQs
#1

Hi,

I have been tracking subitem work hours by using two intermediate columns and following formula:

SUM({Subitem Time Tracking},{Parent Item Time Tracking})/60/60

My questions:

  1. Is there a better method?
  2. Is there a way to add two time columns and output the result as a proper time format (not text!)

Thanks in advance!

#2

I am also curious about this. My formula gives time in decimals but I would like it to be hours and minutes.

#3

Hi there,

It sounds like you are hoping to add 2 time tracking columns and display as HH:MM. If so, I am wondering if this formula helps you achieve it:

(ROUNDDOWN(({Time Tracking1} + {Time Tracking2})& "h " & ": " & (ROUND(MOD(({Time Tracking1}+{Time Tracking2}), 3600)/60, 0)) & “m”

Look forward to your reply!
Andrea

1 Like
#5

would you care to explain this formula? I don’t understand what is going on in the whole

& "h " & ": " & […] & “m”

part

1 Like
#6

I think the “&” connect one string to next one.