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

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

Question on how to calculate median, and how to find the minimum and maximum value of a function, from a large data set for different categories

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 IFS 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. Can you explain to me the workday definition?

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