View Single Post
  #3   Report Post  
janiv janiv is offline
Junior Member
 
Posts: 4
Default

Thanks,
How do I do it in Excel?

Thanks again,


Quote:
Originally Posted by GS[_2_] View Post
janiv was thinking very hard :
Hi,
I have the following hours logged:

03/06/2012 08:38
03/06/2012 23:54
04/06/2012 09:11
04/06/2012 18:50
05/06/2012 08:50
05/06/2012 15:01
06/06/2012 08:42
06/06/2012 19:07
07/06/2012 08:54
07/06/2012 19:08
08/06/2012 19:04
10/06/2012 09:12
10/06/2012 18:33
10/06/2012 21:09
10/06/2012 23:44


How do I calculate how many hours I worked every day?
Something like:
03/06/2012 10:05:00
04/06/2012 08:45:00
10/06/2012 12:46:00

Thanks,
Janiv.


Stop time minus start time, perhaps! Calc this for each day (or
start/stop period) and SUM() to total.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion