Adding time

[HeRoseInThree]

Hey there! I am using Microsoft 365. Could you help write me a excel formula that adds the hours (column q), minutes (column r) and seconds (column s))? Additionally, any seconds that total more than 59 make it a zero and add one minute to the corresponding cell in column r and the same for minutes in column r to hours in column q?

This is what I have and it works on a few rows, but not on all... =IF(OR(Q7="",R7="",S7=""),"",TEXT(Q7+INT((R7+INT(S7/60))/60),"0")&":"&TEXT(MOD(R7+INT(S7/60),60),"00")&":"&TEXT(MOD(S7,60),"00"))

Thanks SO much in advance!!

 

[Fluff]

How about

=IF(COUNTIFS(Q7:S7,">0")=3,TIME(Q7,R7,S7),"")

 

[HeRoseInThree]

Thanks for the reply, but there are a lot of blanks and incorrect results.

 

[Fluff]

Can you post that using the XL2BB add-in. Also what are the correct values.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[HeRoseInThree]

Thanks. I am trying. I am at work, and our security is not letting me. I'll try from home tonight with my laptop.

 

[Fluff]

Ok