Time (clock) times a number

**saadeet** · 04-02-2009, 09:56 AM

I have a start time in one column, end time in another and a column with the difference between the two.
In another column I have profit. In the last column I have profit per hour where I divide the profit by the hours, but since one is hours and the other is a number it gives me an error.

Can anyone suggest a solution?

**NBVC** · 04-02-2009, 10:31 AM

What kind of error do you get?.. if you enter something like 8:00 AM start time and 12:00 PM end time and the difference being 4:00 hours (or 0.166666667
), with Profit of, say, 25 then you won't get an error... you get 150 (25/0.166666667
).

**zbor** · 04-02-2009, 10:34 AM

Maybe easiest way to provide solution would be to upload an example

**saadeet** · 04-02-2009, 10:57 AM

Oh boy, I can't believe it was so simple. I must be very tired or something, because I spent a long time trying to figure this one out. I had the profit per hour configured as time and it should of course just be a number. I figured this out while making an example to upload, so I guess I got the help I needed.
Thank you and sorry for taking up your time with this.

**NBVC** · 04-02-2009, 11:26 AM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thread: Time (clock) times a number

Thread Tools

Display

Time (clock) times a number

Re: Time (clock) times a number

Re: Time (clock) times a number

Re: Time (clock) times a number

Re: Time (clock) times a number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions