Can you help me figure out a Excel formula? I am trying to make a time card
for my boss. With 4 fields. Time-in | Time-Out | Break | Total: My formula
reads =(E11+F11)-(G11)*24 It should give me 8 hours worked. What am I
doing wrong?

There could many things wrong. I'll outline a solution though:

E11 = 8:00 AM (formatted as time)
F11 = 5:30 PM (formatted as time)
G11 = 30 (meaning 30 minutes taken for a break, formatted as general)

The formula in H11 would be:

=((F11-E11)*24)-TEXT(G11,"mm")

....and format that cell N umber.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JBell" wrote:

Can you help me figure out a Excel formula? I am trying to make a time card
for my boss. With 4 fields. Time-in | Time-Out | Break | Total: My formula
reads =(E11+F11)-(G11)*24 It should give me 8 hours worked. What am I
doing wrong?

Sorry, one correction on the break portion:

=((F11-E11)*24)-(G11/60)
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JBell" wrote:

Can you help me figure out a Excel formula? I am trying to make a time card
for my boss. With 4 fields. Time-in | Time-Out | Break | Total: My formula
reads =(E11+F11)-(G11)*24 It should give me 8 hours worked. What am I
doing wrong?