how do I calculate times and get as a result numbers

G

Guest

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

How do I calculate elapsed hours? 2
Calculation of Hrs and Mins from 2 Time Frames 6
How to Calulculate Hrs and Mins between time frames 2
How do i Calculate minutes between two different dates 5
How can I get text to equal a numerical value in Excel? 2
math; How do I multiply a row of numbers quickly? 4
A challenge for an Excel Master... 9
How do I find the amount of hours between times? 1

Top