Timecard Function

DeaninGA

Board Regular
Joined
May 20, 2013
Messages
131
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)
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,187
Members
409,749
Latest member
BorisYeltsin

This Week's Hot Topics

Top