Hello,
I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:
B4 = Start Time
C4 = End Time
D4 = =TEXT(C4-B4,"h:mm") For the calculation
Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.
Thanks.
I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:
B4 = Start Time
C4 = End Time
D4 = =TEXT(C4-B4,"h:mm") For the calculation
Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.
Thanks.