Get instant live Excel expert help with Time and Date Functions

I have a spreadsheet with the first column being times, and the following columns being employee names with the number of patients they checked in at each time. If possible, I would like the times to be displayed in half hour intervals rather than every minute. can i do this?

Hi, I found a bug in an Excel solution provided here about an hour ago. How can I get this resolved? Thank you

making a resthour list for shift workers. 12 hour shifts/ 7 days a week on 4 week rotation. Rresthour list is monthly. I have the shifts and rest hours sorted with formula;s like these =IF('information for form'!$C$13,"x","")&IF('information for form'!$C$14,"x","")&IF('information for form'!$C$16,"x","") What I am looking to do now is that in a single cell i place the joining date and in the other cell the departure date. At the moment the formula works in each cell, so 24 hrs a day and 31 days a month. How can I get excel to ignore the cells prior to the joining date or after departure date?

I would like to ask is it possible in excel to determine if there are duplicate on my data? since It always took me an hour on my data just to check if there are duplicate.

Hello - I am creating an excel spread sheet to track hours for my employees. When my employees close the store, they will enter "CL" in their time sheet. When CL is entered in the cell, i want it to calculate the hours worked +1 hour. For instance, if the employee came in at 3PM and worked until close (which for this example is 9 PM) how do write out the formula to calculate 3-9pm plus and extra hour? 7 total hours. Additionally, if they employee did not work till close, say until 8pm, how do make the cell use the correct forumla?

Is there any way to easily format the words where in the first character was capital and the rest was small caps? since it tooks me an hour just to edit the thousand of data

Hello, I have a column (Named raw data) that contains a time value. The values come in the format of "_ hrs _ mins _ secs" An example is "9 hrs 20 mins 0 secs". However if there is no hour in the raw data, it fills in with “_ mins _ secs”. An example is 40 mins 57 secs. Then I have columns for Hours, Minutes, and Seconds that need to be filled out from the raw data mentioned above.

Is there any way to format names, where in it will automatically capitalize the 1st character and small character for the ff.? since I'm doing it manually for thousands of name and it tooks me an hour.

Can you help me to create a count down timer that will automatically count down each hour. VBA is much better on this.

Please help! My chat just connected after about an hour of working together. Looking for the last rep that helped me PLEASE!!