software

I keep track of my daily work hours using Excel. I enter starting time
in one column and ending time in the next. I would like for the next
column to calculate the total hours worked and rounded to the next
1/10th of an hour. I know it can be done, but I haven’t figured it out
yet. Any help would be very much appreciated.
Popeye--
Popeye
------------------------------------------------------------------------
Popeye's Profile: www.excelforum.com/member.php...oamp;userid=30454
View this thread: www.excelforum.com/showthread...hreadid=501284Hi Popeye

1/10th that would be 6 minutes? If so then try this:

=CEILING(B1-A1,TIME(0,10,0))

HTH
JG

quot;Popeyequot; wrote:

gt;
gt; I keep track of my daily work hours using Excel. I enter starting time
gt; in one column and ending time in the next. I would like for the next
gt; column to calculate the total hours worked and rounded to the next
gt; 1/10th of an hour. I know it can be done, but I haven’t figured it out
gt; yet. Any help would be very much appreciated.
gt; Popeye
gt;
gt;
gt; --
gt; Popeye
gt; ------------------------------------------------------------------------
gt; Popeye's Profile: www.excelforum.com/member.php...oamp;userid=30454
gt; View this thread: www.excelforum.com/showthread...hreadid=501284
gt;
gt;

Oops.....should be:

=CEILING(B1-A1,TIME(0,6,0))

Regards
JG

quot;Popeyequot; wrote:

gt;
gt; I keep track of my daily work hours using Excel. I enter starting time
gt; in one column and ending time in the next. I would like for the next
gt; column to calculate the total hours worked and rounded to the next
gt; 1/10th of an hour. I know it can be done, but I haven’t figured it out
gt; yet. Any help would be very much appreciated.
gt; Popeye
gt;
gt;
gt; --
gt; Popeye
gt; ------------------------------------------------------------------------
gt; Popeye's Profile: www.excelforum.com/member.php...oamp;userid=30454
gt; View this thread: www.excelforum.com/showthread...hreadid=501284
gt;
gt;