Get instant live expert help on how many seconds in hour
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula that will tell me how many people on a schedule (shown in one column) are here with a certain skill (shown in another column) per half hour interval for a full 24 hour period.
Solved by G. W. in 25 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 need help creating a formula that will allow me to see based on 14 days how many people will be coming on each and every hour
Solved by V. A. in 19 mins
I need a formula that correctly gives me the cost for hours billed.
In column D11 it has how many hours I need to bill for (example: 2.00) I charge $250 for the first hour and after the first hour i charge $75 per hour.
So if the total hours = 1.00 its just $250. If its 2.00 hours then its $250+75. If its 3.00 hour its $250+75+75. If its 1.42 hours then its $250+31.25 (as its not a full hour)
Solved by I. U. in 19 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