I should know this and i'm sure its something very simple that just wont come to me. I have two cells, one has "total billable hours" in a month, the second needs to calculate how many days based on that number. So it needs to increase by 1 for every multiplier of 24 in the first cell. Hope this makes sense. Can someone help me with a quick function that will work for this. Any help would be greatly appreciated.
Seems easy so maybe I don't understand the question. If "total billable hours" is in A1 then your formula would be
=A1/24
If you want only a whole numbers of days then
=INT(A1/24)
Are there 24 billable hours in 1 day?
Yeah, that's correct. the problem i'm having is I need it to be a whole number not a decimal or fraction. For anything from 0-24 should count as 1. Anything between 25-48 = 2. 49-72 = 3 and so on.
Just noticed your second part with INT.. Yeah thats it. I knew it was something just looking me right in the face that i wasnt seeing. Thanks 6String. I appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks