I am excel stupid

soxfan9353

New Member
Joined
Aug 9, 2018
Messages
7
So I need help, I am looking to speed up my time card and have it autofill the dates on my time card when input the weekending date.


I can forward you the spread sheet if you want so you can see what i am working with.

Thanks, John
 
Remove personal info, upload the file that shows the 0:00 with my formula in place and post a link, I'll check it out.
 
Upvote 0

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
EMPLOYEE TIME SHEET
NAME:Bailey, John WEEK ENDING:8/12/18
JOBSTARTEND COOK #134 DUPAGE #701 LAKE #150WILL # 176
DATENAMETIMETIMEROTROTROTROTMILEAGEEXPENSESPARKING
8/6/18
8/7/18
8/8/18 8
8/9/18 8
8/10/18 8
8/11/18 0:00
8/12/18 0:00
TOTAL HOURS 000000240
REGULAR HOURS24MILES0PARKING0SIGNATURE
OVERTIME HOURS0EXPENSES0DATE
<colgroup><col width="69"><col width="164"><col width="53" span="2"><col width="39" span="8"><col width="57"><col width="65"><col width="57"><col width="22"></colgroup><tbody> </tbody>
=L$4-(7-ROWS(B$8:B13))
 
Upvote 0
I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book
 
Upvote 0
I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book
It posted just fine. You just need to read the message that it popped back to you that states that your post requires Moderator approval before you can see them on the public forums. Please be patient and wait for approval and do not attempt to post it again (I deleted your duplicate attempt).

This is done on noob accounts to control Spam that is often posted in links and images. A few more posts, and your account will not be subject to this restrictions anymore.
 
Upvote 0
Somehow you got B13:B14 Custom Formatted Date/Time, that's why I had suggested for you to check the formatting in my Post #9 .

Either highlight B13:B14, right click, format cells, choose "Date", OK

Or, select B8, drag the cell handle down (little square at lower right corner of cell) to B14.

Either way will fix it.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top