# greater than time if statements on excel google sheets

1. ## greater than time if statements on excel google sheets

If the time in one column is over 07.30 (7 hours and 30 mins) then I want it to do another calculation. Leaving the remaining minutes over 7hrs 30 mins

Am I on the right track with something like this

Please note D6 would be time out and C6 time in

=if(E6<=TIME(7,5,0)," ","SUM(D6=C6)

2. ## Re: greater than time if statements on excel google sheets

You have a space between the double-quotes - write this as "" instead of " ".

Also, you have SUM(D6=C6), which will return either 1 or 0. I think this should be just D6-C6.

Furthermore, you are comparing E6 with TIME(7,5,0) - should this be TIME(7,30,0), and what is in E6 ??

It would help if you attached a sample Excel workbook, as detailed in the yellow banner at the top of the screen.

Hope this helps.

Pete

3. ## Re: greater than time if statements on excel google sheets

Thanks

I got there in the end with this

4. ## Re: greater than time if statements on excel google sheets

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)