# Timecard Function

#### DeaninGA

##### Board Regular
So I'm trying to create a basic formula that would add 2 blocks of time together and its coming up as ### even when i expand the colum width. Ive placed the formula below. I know it's something simple what am I missing

Thank you
Dean

E11 Morning Punch in
E13 Punch out for Lunch
E17 Punch out to go Home
E15 Punch back in from Lunch

=(E13-E11)+(E17-E15)

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Special-K99

##### Well-known Member
One of those values is prob text or not a valid time.
If you're convinced they are all times copy them to a blank spreadsheet and post a link to it here so we can check.

Replies
3
Views
544
Replies
14
Views
258
Replies
1
Views
257
Replies
5
Views
345
Replies
5
Views
76

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,718
Messages
5,833,289
Members
430,202
Latest member
Faizal5zl

### 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.

### Which adblocker are you using?

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

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