Calculating amount of time spent on a project

gzimmer

What should I put in a query that would, if I have a start time and an
end time, tell me how much time was spent on a project.

Nov 13 '05 #1

Subscribe Post Reply

3122

PC Datasheet

DateDiff("hh:mm",[StartTime],[EndTime])

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<gz*****@linerlaw.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

What should I put in a query that would, if I have a start time and an
end time, tell me how much time was spent on a project.

Nov 13 '05 #2

Rick Brandt

PC Datasheet wrote:

DateDiff("hh:mm",[StartTime],[EndTime])
<gz*****@linerlaw.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
What should I put in a query that would, if I have a start time and
an end time, tell me how much time was spent on a project.

Huh? "hh:mm" is not a valid first argument for DateDiff.

DateDiff("n",[StartTime],[EndTime])

....will give you the minutes though.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

gzimmer

Thank you it worked!

Nov 13 '05 #4

Similar topics

logging time spent on my website

by: Yang Li Ke | last post by:

Hi guys, Im about to build a script which will log visitor time spent on my website. I got a few ideas about this, maybe checking visitors ip and storing that info in db with time in and then...

PHP

Amount of time spent on a record

by: RR | last post by:

What would be a good way to keep track of how much time a form was opened to each individual record? Thanks

Microsoft Access / VBA

Calculating Estimated time?

by: Lars Netzel | last post by:

Hello! I have a number of files to copy. I have to total Amount of files and the Total FileSize of this operation (for example 3453 files, 4065.4 Mb)... How can I calculate how much time this...

Visual Basic .NET

Finding cpu time spent on my program

by: jm.suresh | last post by:

I am trying to measure the time the processor spends on some operation, and I want this measure to not depend on the current load of the machine. But doing the following prints different values...

Python

calculating execution time

by: Umesh | last post by:

i want to calculate the time required to execute a program. Also i want to calcute the time remaining for the execution of the program. how can i do that? pl mention some good websites for...

C / C++

calculating total time using datediff()

by: reshmaarora22 | last post by:

hi i have i table called Description which has details about StartTime , EndTime and ScheduleDate of the various Transaction occuring daily.I want to fetch total time spend on a particular...

Microsoft SQL Server

About time spent have big difference in two running

by: xianwei | last post by:

#include <stdio.h> #include <stdlib.h> #include <time.h> int main ( int argc, char *argv ) { long i = 10000000L; clock_t start, end; double duration;

C / C++

Calculating amount of time that falls into a specific range

by: garyb2008 | last post by:

Hello Can someone help me with this one please! Im working on a service level tracking database which records the times that a service goes down during the day (DowntimeStart/DowntimeEnd) and...

Microsoft Access / VBA

How to create a stopwatch to record time spent on a report.

by: TwoBit | last post by:

Hello Bytes, I am very new at using Microsoft Access and have just recently implicated it in recording productivity on outbound calls for my team. My team is in charge of making outbound calls...

Microsoft Access / VBA

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA