Yet another question about my timesheet

  • Thread starter Thread starter LJustice
  • Start date Start date
L

LJustice

So, I have the formula to round my time entered...but is it possible to enter
the time into the cell with the formula to round the time? I'm trying to make
a timesheet, and can't figure out how they could input their time, and it
would automatically change to the correct rounded time.
 
You enter the actual time in cell A1 and cell B1 contains you're rounding
formula?
 
They want it to be within the same cell - enter into A1 and it converts
automatically within the same cell. Could it be a conditional formatting
issue?
 
Could it be a conditional formatting issue?

No.

If you were to do it as you say, how would you ever know if you made a
mistake? If you do it the way I suggested it will be easy to spot any
mistakes.
 
You must log in or register to reply here.

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

Timesheet in and out rounding 3
Excel Time Rounding in Excel 2
Trouble adding timesheet formulas 1
Rounding hh:mm to nearest 15, 30, 45 minutes 4
Timesheet formula problem 2
Timesheets 2
Bonus/Absence/Timesheet workbook help needed. 6
Time Sheet Summary 1

Back
Top