Ask Experts Questions for FREE Help !
Ask
    jdiesing's Avatar
    jdiesing Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Apr 20, 2009, 09:53 AM
    Time to integer
    what is the formula for calculating integer value of a 24 hr time format. i.e to return 2.75 for the time value of 2:45. I am using this to create a simple time sheet.

    time out-time in = time on job Then to multiply that by a rate to return wage

    Thanks
    jdiesing's Avatar
    jdiesing Posts: 2, Reputation: 1
    New Member
    		  
    #2

    Apr 20, 2009, 10:45 AM
    Pretty silly of me but hopefully someone else gets value out of this answer.

    The value of a date formulated cell is a 24th of a day. So if that value is multiplied by 24 it returns an integer equivalent. 2:45 in C2
    Value(c2)*24 will return 2.75 which is in integer form

    Have a great day.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Student dependent visa UK, Full time or Part time work? [ 26 Answers ]

I have student visa of UK and I study in university. My wife recently came in London. She has student dependent visa. She doesn't study. Can she work full time? How many hours she can work? Thank you

How do I set the day, time and date on a Seiko World Time Touch sensor [ 5 Answers ]

Setting the date, time and day on a Seiko World Time Touch Sensor with 3 buttons in the back

Directions to set time on Seiko World Time Touch Sensor clock. [ 7 Answers ]

I need directions to set the time on Seiko World Time Touch Sensor clock. RefONS901G. Cal YJ20. The clock has a B C buttons to set time. Thanks, Tom Disregard! I figured it out. Thanks, Tom

Integer [ 3 Answers ]

why is this happening? including all necessary header files ,math.h and stdio.h , int main() { int I=2; int y=pow(10,I); printf("%d",y); return 0; }

View more questions Search