Click here to Skip to main content
15,796,102 members
Home / Discussions / C#
   

C#

 
GeneralRe: viewing photo from MySQL Pin
Richard Deeming3-Sep-14 2:54
mveRichard Deeming3-Sep-14 2:54 
GeneralRe: viewing photo from MySQL Pin
Jassim Rahma3-Sep-14 3:26
Jassim Rahma3-Sep-14 3:26 
GeneralRe: viewing photo from MySQL Pin
Jassim Rahma3-Sep-14 3:36
Jassim Rahma3-Sep-14 3:36 
GeneralRe: viewing photo from MySQL Pin
Richard Deeming3-Sep-14 3:43
mveRichard Deeming3-Sep-14 3:43 
GeneralRe: viewing photo from MySQL Pin
Dave Kreskowiak3-Sep-14 4:45
mveDave Kreskowiak3-Sep-14 4:45 
GeneralRe: viewing photo from MySQL Pin
Richard Deeming3-Sep-14 4:52
mveRichard Deeming3-Sep-14 4:52 
GeneralRe: viewing photo from MySQL Pin
Jassim Rahma3-Sep-14 5:12
Jassim Rahma3-Sep-14 5:12 
Questioncalculating total time betweem time ranges Pin
devil54e3-Sep-14 1:28
devil54e3-Sep-14 1:28 
Hi,
i have an sql table which stores times of a machine's 'work start' and 'idle start' times, which is like ;

CSS
2014-09-03 12:50:15  start
2014-09-03 13:45:25  idle
2014-09-03 13:56:06  Start
2014-09-03 16:30:35  idle

.
.
and goes like that.
i need to calculate the time between first start and first idle time after the first start, then, time between second start and first idle after the second start, and it goes like that and there are too many lines. at the and i need total work time and total idle time.
Can anyone help me with this?
Thank you.
AnswerRe: calculating total time betweem time ranges Pin
Richard MacCutchan3-Sep-14 1:55
mveRichard MacCutchan3-Sep-14 1:55 
GeneralRe: calculating total time betweem time ranges Pin
devil54e3-Sep-14 2:12
devil54e3-Sep-14 2:12 
GeneralRe: calculating total time betweem time ranges Pin
Richard MacCutchan3-Sep-14 2:28
mveRichard MacCutchan3-Sep-14 2:28 
GeneralRe: calculating total time betweem time ranges Pin
devil54e3-Sep-14 3:13
devil54e3-Sep-14 3:13 
AnswerRe: calculating total time betweem time ranges Pin
Pete O'Hanlon3-Sep-14 2:09
subeditorPete O'Hanlon3-Sep-14 2:09 
GeneralRe: calculating total time betweem time ranges Pin
devil54e3-Sep-14 2:17
devil54e3-Sep-14 2:17 
AnswerRe: calculating total time betweem time ranges Pin
Richard Deeming3-Sep-14 2:41
mveRichard Deeming3-Sep-14 2:41 
GeneralRe: calculating total time betweem time ranges Pin
devil54e3-Sep-14 3:12
devil54e3-Sep-14 3:12 
GeneralRe: calculating total time betweem time ranges Pin
Richard Deeming3-Sep-14 3:18
mveRichard Deeming3-Sep-14 3:18 
GeneralRe: calculating total time betweem time ranges Pin
devil54e3-Sep-14 3:32
devil54e3-Sep-14 3:32 
QuestionMessage Closed Pin
2-Sep-14 1:42
Group 110523772-Sep-14 1:42 
AnswerRe: mask attack Pin
Rob Philpott2-Sep-14 1:44
Rob Philpott2-Sep-14 1:44 
GeneralRe: mask attack Pin
Group 110523772-Sep-14 2:03
Group 110523772-Sep-14 2:03 
GeneralRe: mask attack Pin
Chris Quinn2-Sep-14 4:02
Chris Quinn2-Sep-14 4:02 
AnswerRe: mask attack Pin
Manfred Rudolf Bihy2-Sep-14 1:56
professionalManfred Rudolf Bihy2-Sep-14 1:56 
AnswerRe: mask attack Pin
Dave Kreskowiak2-Sep-14 2:54
mveDave Kreskowiak2-Sep-14 2:54 
RantRe: mask attack Pin
Eddy Vluggen2-Sep-14 3:57
professionalEddy Vluggen2-Sep-14 3:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.