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'm trying to produce a pivot table on worksheet H showing the number of records by hour for each room based on the NYC (eastern) time. This will require the provided LogTimeStamp time to be converted to our EST from GMT listed in the table worktable worksheet
Solved by X. B. in 26 mins
I have a spreadsheet with temperature data for every hour every day for about three months across 2 dozen sites (columns). In a separate sheet I want to collect the min and max and difference between the two for each date. I thought there must be a way I can set up a formula to collect that info quickly.
Solved by A. L. in 18 mins
I am tracking inspections for aircraft using the aircraft hours and till due inspections. Example: aircraft hours 400 the inspections are on a 25 hour reoccurring basis. I need a formula for counting down the 25 hour inspection as the aircraft hours increase as the inspection comes due then resets for when the inspection was completed. aircraft hours 400 inspection completed at 380 hours till due 5 hours
Solved by I. J. in 15 mins
I am trying to use excel to simulate the charging and discharging of a battery. As in once the battery reaches 1, the level of charge will decrease until it reaches 0 and then begin charging again back to 1. I have tried using multiple IF functions that do not seem to be working as, for example:IFS(cell<=1, cell-10%, cell>0, cell+10%), the array will always continue to decrease or increase past 0 and 1 respectively and will never loop within the range. Hypothetically you can say that it increases 10% an hour from 0-1 and decreases 10% an hour from 1-0. Any help much appreciated thanks.
Solved by G. E. in 11 mins
YOU JUST HELPED ME ONE HOUR AGO WITH PPT SLIDE LABELING THAT WAS CREATED FROM AN EXCEL SPREADSHEET AND IT TOOK ONLY A FEW MINUTES. NEED HELP ONE MORE TIME/ PLEASE I HAVE A DEADLINE IN 1 HOUR
Solved by V. U. in 17 mins
I'm trying to analyse a list of times. Column A has start times, Column B has end times. Column D,E,F,G,H,I are columns that calculate how much time has been lost each hour. E.g. A2 = 07:15 B2 = 07.45 D2 = 30:00 I'm having problems figuring out a formula to calculate times in Column B that overlap the times set for Column D,E,F,G,H,I. E.g. A3 = 07:55 B3 = 08.20 D3 should = 05:00 and E3 should = 20:00 Can you help?
Solved by A. A. in 24 mins
I want to add days to date using Workday.intl formula. Before that simply help me to export case name to the merged cell automatically
Solved by I. U. in 28 mins
I want to find the date by adding the number of working hour as well as date using formula Workday or Workday.intl
Solved by K. Y. in 22 mins
I have a table which lists the schedule of classes for a school. The table is broken down into one hour time slots (columns) and subjects per days of the week (rows). In each time slot per subject is a class number. Each class takes one subject per day. My goal is to say to Excel: "Look in this range and tell me which subjects class X is taking"
Solved by X. H. in 14 mins
Hi, so given check in and check out times of a room in a hospital, I have to find the average room occupancy per hour in a given month.
Solved by D. E. in 25 mins