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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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