Why not just use in D4:On 2002-07-22 12:06, sondriven wrote:
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.
which you format as General?