|
|
Thanks,
How do I do it in Excel?
Thanks again,
Quote:
Originally Posted by GS[_2_]
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
|
|