how do I calculate times and get as a result numbers

I

IgnacioLeon

I got a Spreedsheet that I whant to use as a time sheet, this is so far what
I got done wrong what I want to get is right
a1= 10:00am time in a1= 10:00am
b1= 2:00pm time out (lunch) b1= 2:00pm
c1= 2:30pm time in (lunch) c1= 2:30pm
d1= 8:00pm time out d1= 8:00pm
e1= 8:30 total e1= 8.5

the answer has to be a number if the time is #:0<= #:14 = #.0

#:15<=#:29 = #.25

#:30<=#:44 = #.50

#:45<=#:59 = #.75
I'm using Excel 2002
 

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

calculate time does not calculate 4
Sumproduct with date and time? 0
Sumproduct with date and time? 1
Changing Working Times 4
#VALUE error add'g formulas 2
Over time? 4
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
How do I calculate elapsed hours? 2

Top