Thread: Hour() function
View Single Post
  #1   Report Post  
Steven
 
Posts: n/a
Default Hour() function

I am calculating overtime and have a time of 25:28. That is 25 hours and 28
minutes. It is formatted Custom [h]:mm so you actually see the 25:28 in the
cell. I want to pull the hours into a sererate cell as 25 in this case. I
keep getting a 1 and if I try to add this hour and another number it gives me
another confusing answer.

My question is how do I return the hours (25 in this case) to its own cell
and have it actually be a value of 25.

Thank you for your help.

Steven