clock calculator required

  • Thread starter Thread starter badgolferman
  • Start date Start date
B

badgolferman

I am looking for an application that will take two 24-hour times and
find the difference between the two in tenths of an hour.

My timesheet requires hours charged to projects shown in tenths of an
hour (3.4 hours) and I want to put in values like 0818 to 1142 and have
a difference displayed in hours.

Thanks.
 
I am looking for an application that will take two 24-hour times and
find the difference between the two in tenths of an hour.

My timesheet requires hours charged to projects shown in tenths of an
hour (3.4 hours) and I want to put in values like 0818 to 1142 and have
a difference displayed in hours.
Click to expand...

You need to specify further. As it stands, you've only defined a 12
hour clock. A (AM) and P (PM) must be added for a 24 hour clock.

Secondly, you don't state your rounding preference. How should
0817 be rounded, up or down? It's closer to 8.3 but integer rounding
would make it 8.2

Art

http://home.epix.net/~artnpeg
 
(e-mail address removed), 4/11/2005, 1:29:31 PM,
You need to specify further. As it stands, you've only defined a 12
hour clock. A (AM) and P (PM) must be added for a 24 hour clock.

Secondly, you don't state your rounding preference. How should
0817 be rounded, up or down? It's closer to 8.3 but integer rounding
would make it 8.2

Art
Click to expand...

Okay, I'll be more specific. I need something like this example: 1142
to 1424=2.7 hrs. Input times will always be tenths of an hour so
rounding will not be an issue.
 
Le 11 Apr 2005 17:54:47 GMT, badgolferman a écrit :
(e-mail address removed), 4/11/2005, 1:29:31 PM,


Okay, I'll be more specific. I need something like this example: 1142
to 1424=2.7 hrs. Input times will always be tenths of an hour so
rounding will not be an issue.
Click to expand...

string & time functions and/or macro with OpenOffice Calc ?
http://www.openoffice.org/

@+
 
Okay, I'll be more specific. I need something like this example: 1142
to 1424=2.7 hrs. Input times will always be tenths of an hour so
rounding will not be an issue.
Click to expand...

No, your input times are apparently in hours:minutes, and minutes are
1/60 hour, not 1/10 hour. So my question concerning rounding stands.

0817 is 8.283333 so you have to decide if you prefer rounding down
to 8.2 or rounding up to 8.3.

Art

http://home.epix.net/~artnpeg
 
Badgolferman,

I revised a simple program I wrote and it does what you asked for.
It's only 5KB, and is completely free of spy-, ad-, or any other mal-ware
(where would it fit anyway?!)
I can e-mail it to you if you're interested.

Regards,
Eric
 
(e-mail address removed), 4/11/2005, 3:03:20 PM,
of >> > an hour (3.4 hours) and I want to put in values like 0818 to
1142 >> > and have a difference displayed in hours.

No, your input times are apparently in hours:minutes, and minutes are
1/60 hour, not 1/10 hour. So my question concerning rounding stands.

0817 is 8.283333 so you have to decide if you prefer rounding down
to 8.2 or rounding up to 8.3.

Art
Click to expand...

It seems I am having trouble understanding you or I am not stating my
question clearly.

We calculate our hours by six minute increments, hence 1500 to 1536
equals .6 hours. Whether I actually started a job at 1458 or 1503 I
would still choose 1500 as the starting time. We round up our time
only in the sense that we choose on paper the six-minute increment of
the hour to identify the start and stop time. I would not enter any
time in the minutes column other than :00, :06, :12, :24, :30, etc.
 
(e-mail address removed), 4/11/2005, 3:37:18 PM,
Badgolferman,

I revised a simple program I wrote and it does what you asked for.
It's only 5KB, and is completely free of spy-, ad-, or any other
mal-ware (where would it fit anyway?!)
I can e-mail it to you if you're interested.

Regards,
Eric
Click to expand...

Please do. You can figure out my address.
 
It seems I am having trouble understanding you or I am not stating my
question clearly.

We calculate our hours by six minute increments, hence 1500 to 1536
equals .6 hours. Whether I actually started a job at 1458 or 1503 I
would still choose 1500 as the starting time. We round up our time
only in the sense that we choose on paper the six-minute increment of
the hour to identify the start and stop time. I would not enter any
time in the minutes column other than :00, :06, :12, :24, :30, etc.
Click to expand...

You weren't stating your question clearly :)


http://home.epix.net/~artnpeg
 
It seems I am having trouble understanding you or I am not stating my
question clearly.

We calculate our hours by six minute increments, hence 1500 to 1536
equals .6 hours. Whether I actually started a job at 1458 or 1503 I
would still choose 1500 as the starting time. We round up our time
only in the sense that we choose on paper the six-minute increment of
the hour to identify the start and stop time. I would not enter any
time in the minutes column other than :00, :06, :12, :24, :30, etc.
Click to expand...

Why don't you just enter the start and stop times as decimals of an
hour? Using your example:

start (08:18) = 8.3
end (11:42) = 11.7

Susan
--
Posted to alt.comp.freeware
Search alt.comp.freeware (or read it online):
http://google.ca/advanced_group_search?q=+group:alt.comp.freeware
Pricelessware & ACF: http://www.pricelesswarehome.org
Pricelessware: http://www.pricelessware.org (not maintained)
 
Susan said:
Why don't you just enter the start and stop times as decimals of an
hour? Using your example:

start (08:18) = 8.3
end (11:42) = 11.7

Susan
Click to expand...

That is what I have to do now. The problem is I have to use my brain
and it hurts too much on Friday mornings. Then I mess up my timesheet
and have to make corrections. I was hoping there would be an easier
way to do it.
 
badgolferman said:
Susan Bugher, 4/11/2005, 4:36:25 PM, wrote:
Click to expand...
That is what I have to do now. The problem is I have to use my brain
and it hurts too much on Friday mornings. Then I mess up my timesheet
and have to make corrections. I was hoping there would be an easier
way to do it.
Click to expand...

I think it's Friday here already. ;) What I was *trying* to suggest was
that when you start or end a job you write the start/end times down as
decimal hours instead of hours and minutes - then you won't have to do
any converting.

Susan
--
Posted to alt.comp.freeware
Search alt.comp.freeware (or read it online):
http://google.ca/advanced_group_search?q=+group:alt.comp.freeware
Pricelessware & ACF: http://www.pricelesswarehome.org
Pricelessware: http://www.pricelessware.org (not maintained)
 
Susan said:
I think it's Friday here already. ;) What I was *trying* to suggest was
that when you start or end a job you write the start/end times down as
decimal hours instead of hours and minutes - then you won't have to do
any converting.
Click to expand...

or get Xcalc:

Program: Xcalc
Author: Bernt Ribbum
Ware: Freeware
http://www.tordivel.no/xcalc/

The keys labeled D.ms and D.dd convert back and forth from hours (or
degrees), minutes and seconds to the decimal equivalent.

XCALC version 2.6.3 (161 kB zip)
http://www.tordivel.no/files/xcalc263.zip

Susan
--
Posted to alt.comp.freeware
Search alt.comp.freeware (or read it online):
http://google.ca/advanced_group_search?q=+group:alt.comp.freeware
Pricelessware & ACF: http://www.pricelesswarehome.org
Pricelessware: http://www.pricelessware.org (not maintained)
 
badgolferman said:
I am looking for an application that will take two 24-hour times
and find the difference between the two in tenths of an hour.

My timesheet requires hours charged to projects shown
in tenths of an hour (3.4 hours) and I want to put in values
like 0818 to 1142 and have a difference displayed in hours.
Click to expand...

Cousin badgolferman ....

Got python ?

python time_diff.py 1142 1424

Elapsed Time .... 2.70 hours

Always use 4 digits for times
and make sure time-out is greater than time-in ....

0411
0832

Save the following as time_diff.py ....

# ---------------------------------------

import sys

def minutes( this_time ) :

str_hour = this_time[ 0 : 2 ]

str_min = this_time[ 2 : 4 ]

return ( int( str_hour ) * 60 ) + int( str_min )


tin = sys.argv[ 1 ]

tout = sys.argv[ 2 ]

o_min = minutes( tout )

i_min = minutes( tin )

et = ( o_min - i_min ) / 60.00

print
print ' Elapsed Time .... %.2f hours' % ( et )
print

# -----------------------------------------------
 
badgolferman said:
I am looking for an application that will take two 24-hour times
and find the difference between the two in tenths of an hour.

My timesheet requires hours charged to projects shown
in tenths of an hour (3.4 hours) and I want to put in values
like 0818 to 1142 and have a difference displayed in hours.
Click to expand...

Cousin badgolferman ....

Got python ?

python time_diff.py 1142 1424

Elapsed Time .... 2.70 hours

Always use 4 digits for times
and make sure time-out is greater than time-in ....

0411
0832

Save the following as time_diff.py ....

# ---------------------------------------

import sys

def minutes( this_time ) :

str_hour = this_time[ 0 : 2 ]

str_min = this_time[ 2 : 4 ]

return ( int( str_hour ) * 60 ) + int( str_min )


tin = sys.argv[ 1 ]

tout = sys.argv[ 2 ]

o_min = minutes( tout )

i_min = minutes( tin )

et = ( o_min - i_min ) / 60.00

print
print ' Elapsed Time .... %.2f hours' % ( et )
print

# -----------------------------------------------
Click to expand...

Thank you for whatever this is, but it is over my head. No, I don't
know what Python is.
 
Boco said:
found it here: ftp://ftp.rrz.uni-koeln.de/pc/win32/calc/xcalc263.zip
Click to expand...

Thanks for that. :)

The Xcalc site was there yesterday - I checked before posting (I have
the file too if needed). Let's hope it's a temporary problem.

Susan
--
Posted to alt.comp.freeware
Search alt.comp.freeware (or read it online):
http://google.ca/advanced_group_search?q=+group:alt.comp.freeware
Pricelessware & ACF: http://www.pricelesswarehome.org
Pricelessware: http://www.pricelessware.org (not maintained)
 
Back
Top