Calculating time spent

[Muthoni]

I have a spreadsheet tracking time spent on events. I want to ignore anything under 6minutes. How can I achieve this?

 

[Joe4]

Welcome to the Board!

Ignore it how/where?
Do you mean from totals?

If so, you can use a SUMIF formula to exclude anytime less than 6 minutes from your sum.
See: SUMIF function - Microsoft Support

 

[Muthoni]

My formula takes into account time spent on a task and I am deriving a payment based on time. I want to exclude from paying anything that’s under six min. Hope this makes sense.

 

[Joe4]

Please don't mark a post as the solution if you don't have a solution yet!

If you need detailed help, I think it would be best to show us a sample of your data and expected results.

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.

 

[Muthoni]

Please don't mark a post as the solution if you don't have a solution yet!

If you need detailed help, I think it would be best to show us a sample of your data and expected results.

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.

Thank you got it.

 

[Joe4]

Thank you got it.

You are welcome. You can post it right back in this thread.

 

[Umma123]

You should try filter, apply a filter to the column with your times. Then set the filter to show only times that are equal to or greater than 6 minutes.

 

[Muthoni]

You should try filter, apply a filter to the column with your times. Then set the filter to show only times that are equal to or greater than 6 minutes.

This worked thank you.