Get instant live Excel expert help with Time and Date Functions

“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

I have created a spreadsheet to track resource usuage and costs by hour over a number of months. I need a formula that sums the hours in a date range and multiplys by looking up an hourly rate from another sheet. This will be used to summarise monthly costs for a each person.
Solved by G. Q. in 25 mins
Number of orders in each hour at parent zone.
Solved by T. C. in 27 mins
Good Afternoon, I need to calculate the time remaining between now (current hour) and a deadline hour. I need a formula which could help out if possible please?
Solved by M. U. in 14 mins
Pivot Table - count of active drivers in each hour.
Solved by C. Y. in 20 mins
How to round off numbers in excel? I want to round military times to nearest quarter hour. "START" column
Solved by V. H. in 22 mins
How do I count the number of times something happens during a given time range? For example at the 9am, 10am, 11am, (during the entire hour) etc how many people purchased a book. Note the timestamp is inclusive of the date and time of day
Solved by I. F. in 27 mins
I am trying to do a time sheet in 100 hour time and have it calculate the time worked less breaks
Solved by E. H. in 22 mins
How do i obtain the hour with lowest concentration of rides from a pivot table?
Solved by Z. Q. in 15 mins
I need to graph my data to show how many specific objects per hour of the day
Solved by G. C. in 30 mins
I am making an apprenticeship hour log. In B2, for example, I have hours needed as 2200, they put in how many hours worked in that area in B3. I can subtract that amount and show it in B4 but how do I keep the new amount in B4 for the next week. I.E. 2200 hours needed (B2) 10 hours worked in B3 new number in B4 2190. I need to keep the 2190 for the next week. I can't figure out how to keep it 2190 when B3 clears? Help?
Solved by D. D. in 18 mins