In Excel, date and time is converted to a number, and an hour is recorded as a fraction of a 24 hour day, or 0.042, so when you divide your profit of "100" you get 2400.
HTH
In Excel, date and time is converted to a number, and an hour is recorded as a fraction of a 24 hour day, or 0.042, so when you divide your profit of "100" you get 2400.
HTH
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks