timecard

  • Thread starter Thread starter vdmbqb
  • Start date Start date
V

vdmbqb

I need a simple formula.

Cell A1 is begin time and cell B1 is end time, both are entered in hours and
minutes.
I need the formula in C1 for the difference between the two in hours and
minutes.

Thank you SO SO Much
 
Assume in-out times entered in cols A and B from row2 down like this

In Out
8:00 18:00
etc

Put in C2, copy down: =B2-A2
will return the required results
 
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

Difference between dates and times 5
Converting dd:hh:mm to [h]:mm not working. 3
Rounding time 2
Subtraction formula with Text error 7
Ignore text in timecard calculation 1
Calculating time in minutes 10
subtracting date and time to find the difference between the two 4
Dividing meters by hours = meters per hour 7

Back
Top