Get instant live expert help on how many seconds in 24 hours
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
=IF((((AL4-AJ4)+(AP4-AN4))*24)>8,8,((AL4-AJ4)+(AP4-AN4))*24)
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
Solved by S. H. in 30 mins
I want to sum up hours minutes and seconds
Solved by E. D. in 25 mins