hours to calculate cost per minute

[marreco]

Hi.
A1 - = now () Suppose it is 10:00
A2 - 10:45 refers to the time of completion of work
A3 - (A1 - A2) * 24 When I make this account gives an absurd number
A4 - Cost of 30.00 minutes
A5 - A3 x A4


I can not make this account due to cell A3 to an absurd number. Now, when I use the formula = NOW () gives the right account


thank you very much

 

[pplstuff]

Do you have a question? What happens when now() is after the time of completion? Does this data get moved to a database?

 

[shg]

Now includes the date.

A3: =(MOD(A1,1) - A2) * 24

... though it seems odd that the completion time is greater than the current time.

 

[marreco]

Hi. shg
Thanks my problem was resolved