Search results
Dec 7, 2012 · I have a requirement to convert the date and time through excel. for example: now the current time is 18:30 (A1) IST and put the formula in excel (A1-"10:30") i got the O/P 8:00. I am not getting the correct time when the time is 2:00 AM. Thanks in Advance. Please help in this?
Feb 10, 2005 · This is what I have in range B1:B7 12:00AM 12:30AM 1:00AM 1:30AM 2:00AM 2:30AM 3:00AM I want to convert these times into (IST +9:30) and put them in A1:a7 Sheshadri
We have server in Troy(USA).So we are in the situation to convert EST DateTime to IST DateTime in EXCEL. If you have any formula or Idea share with me. Eg; EST : 04/03/09 09:31:53 (I/P) IST : 04/03/09 07:01:53 (O/P) Thanks in Advance.
Mar 21, 2016 · IST to EST AND EDT convertion. Thread starter kalyansrinivas143; Start date Jun 2, 2016; K ...
convert EST date and time to IST date and time through excel. I have a requirement to convert the date and time through excel. for example: now the current time is 18:30 (A1) IST and put the formula in excel (A1-"10:30") i got the O/P 8:00.
I put all the workers under the column C and to mark there shift times I color the cell YELLOW and put a YELLOW A in the hours they work. (i.e.: Jim works 7am to 5pm EST I have a yellow row from 7-5 with a yellow A marking the cells) I have 2 of the worksheets: EMEA & APJ -In cell E3 I have GMT & CET then IST & SING
Jul 23, 2011 · I opened the Name Manager and just happened to notice that three sheets in one of my workbooks has the name "_FilterDatabase" defined. A search indicates that these are hidden names created when I do a filter. These don't seem to be very well hidden and the only filter that I know that I have...
Nov 21, 2008 · I have a drop down list with 3 option, (Yes, No or DK). I am trying to count the number of times Yes appears in the column. I'm certain that I have the countif formula set up correctly. However, I am getting a value of O as a result. I get the same result if I change the Criteria to No or DK...
May 21, 2021 · I am using a formula that calculates holidays for each year so I can use it with NETWORKDAYS to exclude weekends and "OBSERVED" holidays For example, my formula for the examples below would return Saturday, December 25, 2021 for Christmas: New Years Day -...
Dec 13, 2018 · Option Explicit Public Sub Main_List_Folders_and_Files() With ActiveSheet .Cells.Clear List_Folders_and_Files "C:\list", .Range("A1") End With End Sub Private Function List_Folders_and_Files(folderPath As String, destCell As Range) As Long Dim FSO As Object Dim FSfolder As Object, FSsubfolder As Object, FSfile As Object Dim folders As Collection, levels As Collection Dim subfoldersColl As Collection Dim n As Long, c As Long, i As Long Set FSO = CreateObject("Scripting.FileSystemObject") Set ...
