Keeping track of and totaling hours worked

[Popeye]

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

[pinmaster]

Hi Popeye

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

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

HTH
JG

"Popeye" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=30454
> View this thread: http://www.excelforum.com/showthread...hreadid=501284
>
>

[pinmaster]

Oops.....should be:

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

Regards
JG

"Popeye" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=30454
> View this thread: http://www.excelforum.com/showthread...hreadid=501284
>
>