Still Stuck in TIME - Pivot table and time
Sorry to beat a dead horse, but still stuck with the 24 hour issue of time. I attached a sheet to show wmy problem. When you go from 0700-0700, I get 0 for my answer. Plus on my pivot table, my grand totals equal Zero.
Thanks
expert-exchange.xlsx
Thanks
expert-exchange.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go with matthews formula and you can change the number format in the PivotTable and sheet to [h]:mm:ss
-RK expert-exchange-v1.xlsx
-RK expert-exchange-v1.xlsx
ASKER
Yes, using your formula, I do get same results. I am trying to simplfy the process, but might have to include date with time.
Time IN Time OUT "Total
Hours"
7:00 15:47 18:48
15:47 18:00 5:12
18:00 7:00 0:00
7:00 7:00 0:00
Time IN Time OUT "Total
Hours"
7:00 15:47 18:48
15:47 18:00 5:12
18:00 7:00 0:00
7:00 7:00 0:00
Thats because of the number format. Regular time format is "hh:mm:ss" which goes around in 24 hours. now [h]:mm:ss sums the hours even over 24...
ASKER
Yes, thank you. It was the formatt I was messing up.
ASKER
I have been playing with this formula, but still not good.
=IF(E6=F6,TIME(23,59,59)+T
Thank you