How to set time formate in datagridview cell in c#

Pavithra L

10y1.7k.NET

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.

24 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Aman10y ago
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
0
Pavithra L10y ago
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.
0
Pavithra L10y ago
Hai Gowtham ,
I am already used this code , but am not get the correct answer.
0
Mohammad Aman10y ago
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 < 10 ? "0" + tshour1.Minutes : tshour1.Minutes.ToString());
Response.Write("FirstTotalHrs: " + FirstTotalHrs + "
");

0
Ravi Kumar10y ago
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";
0
Gowtham Rajamanickam10y ago
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); } }
0
Raja T10y ago
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
0
Pavithra L10y ago
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.
0
Raja T10y ago
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.
0
Pavithra L10y ago
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.
0
Mohammad Aman10y ago
Use one pf them functions
```
TimeSpan.TryParseExact()
```
```
      OR
```
```
TimeSpan.ParseExact()
```
https://msdn.microsoft.com/en-us/library/ee372287(v=vs.110).aspx
0
Ravi Kumar10y ago
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) ;
0

Raja T10y ago

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 Kumar10y ago
string num = "1110";
string result = num.Substring(0, 2) + ":" + "00";
0
Pavithra L10y ago
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.
0
Ravi Kumar10y ago
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";

0
Pavithra L10y ago
Hai Ravi,

It was show the error is Invalid expression term 'if'.

How to overcome this and time variable is not accepted.
0
Pavithra L10y ago
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.
0
Ravi Kumar10y ago
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
0

Mohammad Aman10y ago

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 L10y ago
Hai,

It is not working again it was showing an error. Is there any other possibilities to overcome this.
0
Ravi Kumar10y ago
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";
0
Pavithra L10y ago
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.
0
Ravi Kumar10y ago
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";
0