Thread: Time Stats

Hi, I am looking to create a spreadsheet that will allow me to see a breakdown of every 15 mins in order to see someones stats for a whole dat

I have attached a sample spreadsheet of what I am looking to get, but dont know how to write this in a formula. If somebody could somebody help me.

For example:

If i have a person who has worked between 09:00 till 09:35 then i would like to see the following:

| 09:00 | 09:15 | 09:30 |
Mickey | 15 | 15 | 5 |

Hope that makes sense.

Thanks in advance.

DonkeyOte, thanks that works exactly the way i need it. Really appreciate it.