How to set time formate in datagridview cell in c#

Question

Hai,

In my project I need to enter the machine running time , Total running time and Idle time in datgridview cells .

Here I want to set the time format in datgridview cells, which means I just enter only the number ,system will separate the hour and minutes.

For an example:

I am just typing only the numbers 1100,1200 like vise.

starttime	endtime	totaltime	idle time
11:00AM	12:00PM	13:00	02:00

How can I do this. Here total time will calculate automatically based on the start and end time . How can I do this , please anybody help this question I need to finish it quickly.

Thanks in advance.

Mohammad Aman · Answer

Improve this code by using switch cases OR if-else conditions .... then u will get your desire output ... My code is working and running without error,,,, now you need to improve this only according your need. If you are not able to improve then tell me ...... i will help you

Pavithra L · Answer

Hai Mohammad , Your program result shows only the first 2 digit value. I don't want this . I can just separate four digit value as digit . Exampe 1120=11:20 and also separate the three digit value as 120=01:20. Are you clear now. Please leave above conversation. This is the exact question to solve . Thank you for your kind co-operation.

Pavithra L · Answer

Hai Gowtham , I am already used this code , but am not get the correct answer.

Mohammad Aman · Answer

Now use this code tested and working properly ... this is implemented by me string FirstTotalHrs = string.Empty; string total = "1200"; string hour1= total.Substring(0,2); string hour1minutes = total.Substring(2,2); TimeSpan tshour1 = new TimeSpan(Convert.ToInt32(hour1), Convert.ToInt32(hour1minutes), 00); FirstTotalHrs = Math.Floor(tshour1.TotalHours) + ":" + (tshour1.Minutes Response.Write("FirstTotalHrs: " + FirstTotalHrs + " ");

Ravi Kumar · Answer

int i = dataGridView1.CurrentCell.RowIndex; string s=dataGridView1.Rows[i].Cells[0].Value.ToString() ; dataGridView1.Rows[i].Cells[1].Value =s.Substring(0,2) +":"+"00";

Gowtham Rajamanickam · Answer

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { string input = dataGridView1.CurrentRow.Cells[0].Value.ToString(); if (e.ColumnIndex == 1) { dataGridView1.CurrentRow.Cells[1].Value = input.Substring(0, 2) + ":" + input.Substring(2, 2); } }

Raja T · Answer

Hi, Please check debug mode string input = dataGridView1.CurrentRow.Cells[0].Value.ToString(); here dataGridView1.CurrentRow.Cells[0].Value.ToString(). Index 0 values not existing in datagridview cells array please check

Pavithra L · Answer

Hai, private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { string input = dataGridView1.CurrentRow.Cells[0].Value.ToString(); if (e.ColumnIndex == 1) { dataGridView1.CurrentRow.Cells[1].Value = input.Substring(0, 2) + ":" + input.Substring(2, 2); } } This is my code . In that first line only show that error.

Raja T · Answer

Please share your query..What u have tried? Please check query contains record are exists or not? If yes show me query out put here.

Pavithra L · Answer

Hai Raja, I am using your query , But it was showing this error : object reference not set to an instance of an error. But it will separate the strings . Thanks.

Mohammad Aman · Answer

Use one pf them functions TimeSpan.TryParseExact() OR TimeSpan.ParseExact() https://msdn.microsoft.com/en-us/library/ee372287(v=vs.110).aspx

Ravi Kumar · Answer

first question solution check below string a, b; a = "1100".Substring(0, 2); b = "1200".Substring(0, 2); if (Convert.ToInt32(a) > 12) a= a + ":" + "00" + " PM"; else a = a + ":" + "00" + " AM"; if (Convert.ToInt32(b) > 12) b = b+ ":" + "00" + " PM"; else b = b + ":" + "00" + " AM"; messagebox.show(a+"-"+b) ;

Raja T · Answer

Hello Pavithra, string input = "1100" ; string sub = input. Substring (0,2 )+":"+ input. Substring (2,2); Console.WriteLine("Substring: "+ sub) more details checkout below url http://www.dotnetperls.com/substring

Ravi Kumar · Answer

string num = "1110"; string result = num.Substring(0, 2) + ":" + "00";

Pavithra L · Answer

Hai Ravi, This is also not working, Ok leave all these things , Now I just want to separate the string ex(1110) like this will be separate 11:00 like this. This is the concept now. Is there any idea to solve this please share your code. Thank you for your kind co-operation.

Ravi Kumar · Answer

soryy try this if(convert.toInt32(convert.tostring(time).substring(0,1))>12) convert.tostring(time).substring(0,1) +":" +convert.tostring(time).substring(2,3) +"PM"; else convert.tostring(time).substring(0,1) +":" +convert.tostring(time).substring(2,3) +"AM";

Pavithra L · Answer

Hai Ravi, It was show the error is Invalid expression term 'if'. How to overcome this and time variable is not accepted.

Pavithra L · Answer

Hai Mohammad, Can you understand my qusetion . I need to enter the hour and minute in the datagridview cell and it will automatically separate the time. and also show the AM and PM format. How can I do this please tell me any suggestion. Need to finish this topic quickly.

Ravi Kumar · Answer

if(convert.toInt32(convert.tostring(time).substring(0,1))>12) if(convert.tostring(time).substring(0,1) +":" +if(convert.tostring(time).substring(2,3) +"PM"; else if(convert.tostring(time).substring(0,1) +":" +if(convert.tostring(time).substring(2,3) +"AM"; try again this what error your getting

Mohammad Aman · Answer

Hi I hope it will help : TimeSpan span = TimeSpan . FromHours ( 16 ); DateTime time = DateTime . Today + span ; String result = time . ToString ( "hh:mm tt" ); OUTPUT: 04 : 00 PM See here time formats https://msdn.microsoft.com/en-us/library/az4se3k1.aspx Demo Link: http://ideone.com/veJ6tT

Pavithra L · Answer

Hai, It is not working again it was showing an error. Is there any other possibilities to overcome this.

Ravi Kumar · Answer

if(convert.tostring(time).substring(0,1)>12) if(convert.tostring(time).substring(0,1) +":" +if(convert.tostring(time).substring(2,3) +"PM"; else if(convert.tostring(time).substring(0,1) +":" +if(convert.tostring(time).substring(2,3) +"AM";

Pavithra L · Answer

Hai Ravi, Error 14 'System.DateTime' does not contain a definition for 'substring' and no extension method 'substring' accepting a first argument of type 'System.DateTime' could be found (are you missing a using directive or an assembly reference?) Error 15 Only assignment, call, increment, decrement, and new object expressions can be used as a statement it was show n this error. How to reduce this.

Ravi Kumar · Answer

if(time.substring(0,1)>12) time.substring(0,1) +":" +time.substring(2,3) +"PM"; else time.substring(0,1) +":" +time.substring(2,3) +"AM";

How to set time formate in datagridview cell in c#

Tirthak Shah