Keeping track of and totaling hours worked

P

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
 
G

Guest

Hi Popeye

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

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

HTH
JG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding the total hours worked in 5 weeks 2
How do I calculate profit per hour in excel? 1
Add If formula in macro (replace cell text value with numeric valu 1
Keep total of cells in a cell after deleting source data 8
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
Work hours with overtime 2
why is answer rounded up? 1
how to keep track of work hours and my tips 2

Top