Search results for query: *

Hello, I'm looking for a code that makes it possible in excel to keep track off the number of documents. For example: in a cell we start with EXAMP001. when u save this sheets and something has been changed in the sheet, then this number is somehow saved to another worksheet mentioning what...

Is there a function in Word that can be used as the LOOKUP or VLOOKUP function, used in Excel? thx gaime

I'm sorry but I'm really a newbie, what should I do exactly? I pasted the lines you gave me in the boxes I also put TimeDur. I tried to compile (because I didn't really know what I was supposed to do) and it gave the error: [COLOR=red]compile error: Invalid outside procedure[/color red] can...

dhookom, [COLOR=brown] Begin Einde[/color brown][COLOR=blue] 22:00 23:55 21:24 22:00 17:28 17:48 09:00 09:19 14:00 14:12 04:24 04:34 06:00 06:10 18:27 18:36 04:15 04:23 07:10 07:18 00:37 00:45 [/color blue] this is an example of what is in the database. There are no time fields blank because a...

PHV, I tried your option with following text: [COLOR=green]SELECT S.txtDatum AS Datum, M.Cell AS Cel, S.txtFCode AS Foutkode, Sum(IIf(S.txtBeginStoring<=S.txtEindeStoring, CDate(Left(S.txtEindeStoring,2) & ":" & Right(S.txtEindeStoring,2) & ":00")-CDate(Left(S.txtBeginStoring,2) & ":" &...

Dhookom, I tried your option but it didn't work. Is there something I might change so Id would work? thx gaime

dhookom, I tried your option and got result: the number of minutes is counted, but differ from each other. some minutes are shown like this [COLOR=green]1, 5 , 135[/color green] but there are also times who are shown like: [COLOR=green]20.000000, 5.0000000, 2.0000000, ...[/color green] Is...

Sorry PHV, I want the downtimes to be calculated by [COLOR=green]Date[/color green]. thx gaime

Hi, I'm looking for a graph that can show clusters, is this possible in Excel? For exemple: There are some isues that need to be solved by several persones. I need a graph that shows time on the X-axis and thus bars that start on the Y-axis ranging untill the right date (and thus shows how...

Your right dhookom, if I added 'Datum', I got 'Cel', and so on ... The values look like "xx:xx" but is guess they are stored like "xxxx". Maybey if I started a new query leaving all tables out who are nog realy necessary (except txtDatum), and then: [COLOR=green] SUM ( ....) Group By...

I tried this code: [COLOR=green] SELECT tblStoring.txtDatum AS Datum, tblMachine.Cell AS Cel, tblStoring.txtFCode AS Foutkode, tblStoring.txtBeginStoring AS [Begin], tblStoring.txtEindeStoring AS Einde, IIf([txtBeginStoring]<=[txtEindeStoring],Format(CDate(Left([txtEindeStoring],2) &...

I tried this code: [COLOR=green] SELECT tblStoring.txtDatum AS Datum, tblMachine.Cell AS Cel, tblStoring.txtFCode AS Foutkode, tblStoring.txtBeginStoring AS [Begin], tblStoring.txtEindeStoring AS Einde, IIf([txtBeginStoring]<=[txtEindeStoring],Format(CDate(Left([txtEindeStoring],2) &...

I tried this: [COLOR=green] Format(([Downtime] & ":00"),"Short Time") As TotalDowntime [/color green] so I figured I now have times If I try to sum them like this: [COLOR=green] SUM(Format(([Downtime] & ":00"),"Short Time")) As TotalDowntime [/color green] It doesn't work. I get the...

I tried your option but I had the following error: [COLOR=red]Data type mismatch in criteria expression. [/color red] Another question I asked myself: it is necessary that downtime who include midnight also are counted correctly. with the expression I have already this is done (I don't think...

Because I'm working with somebody else his database (at work) and there are many records, and I'm not so keen on making changes which may damage the database. So I would like to find a solution for the database as it is (with its malfunctions). I already asked myself the same question, why he...

Hi guys, I need some expert help about a problem I'm having with summing up times. The times are given in by a mask [COLOR=green] "__:__" [/color green]. So the times range from "00:00" to "23:59". With some help I made a table who tells the downtimes of a cell (it's for calculating downtimes...

Thx, works very nice. gaime

I guess it's the +24 piece that's wrong gaime

This string doesn't work, IIf([txtBeginStoring]<=[txtEindeStoring], Format(CDate(Left([txtEindeStoring],2) & ":" & Right([txtEindeStoring],2) & ":00")-CDate(Left([txtBeginStoring],2) & ":" & Right([txtBeginStoring],2) & ":00"),"hh:nn"), Format(CDate(Left([txtEindeStoring]+24,2) & ":" &...

It should be: validation: If EindeStoring < Begintime then downtime = (EindeStoring + 24h) - BeginStoring. ofcourse gaime