“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=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