Here are some problems that our users have asked and received explanations on
When I key in the time in the time sheets and use this formula to calculate how many hours worked it says 8 no matter what times are keyed in
Solved by E. E. in 16 mins
How can you change duration in hh:mm:ss to dd:hh:mm:ss (if hh exceeds 24 hours?)
Solved by A. F. in 21 mins
I have data being recorded every 30 seconds displayed in one cell as "mm/dd/yyyy hh:mm:ss AM/PM". How do I filter the rows so I get only one data point every 6 hours instead of every 30 seconds?
Solved by K. F. in 27 mins
hi, base hours is 9:00 am, when i add hours its fine i.e. 9:00+2/24, however when i deduct 13 i.e. 9:00-13/24, it gives result in #######, how to rectify this