Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Time Display in a Stop Watch fromat

Is there a way to format a cell's time in a "stop watch" format, without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested (0:00).
Any help is greatly appriciated. Thanks.

  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default Time Display in a Stop Watch fromat

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format, without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested (0:00).
Any help is greatly appriciated. Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Time Display in a Stop Watch fromat

I am looking to have the formula bar read 0:00 as well. So when I click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00, 2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format, without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested (0:00).
Any help is greatly appriciated. Thanks.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Time Display in a Stop Watch fromat

See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gabe" wrote in message
...
I am looking to have the formula bar read 0:00 as well. So when I click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00, 2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format,

without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested

(0:00).
Any help is greatly appriciated. Thanks.



  #5   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Time Display in a Stop Watch fromat

Thanks for the info, but I think I figured it out. Excel stores dates and
times as serial numbers. I have to input the correct dates as well otherwise
it is trying to subtract the past. Example: 1pm 1/1/1900 from 12am 1/1/1900.
It's too bad excel does'nt have a basic stop watch format, maybe they should
make one in a new version. Thanks.

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gabe" wrote in message
...
I am looking to have the formula bar read 0:00 as well. So when I click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00, 2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format,

without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested

(0:00).
Any help is greatly appriciated. Thanks.






  #6   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Time Display in a Stop Watch fromat

How would it tell the difference between 340 as in 03:40 or 340 as in the
integer 340?

--

Regards,

Peo Sjoblom

"Gabe" wrote in message
...
Thanks for the info, but I think I figured it out. Excel stores dates and
times as serial numbers. I have to input the correct dates as well

otherwise
it is trying to subtract the past. Example: 1pm 1/1/1900 from 12am

1/1/1900.
It's too bad excel does'nt have a basic stop watch format, maybe they

should
make one in a new version. Thanks.

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gabe" wrote in message
...
I am looking to have the formula bar read 0:00 as well. So when I

click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00,

2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format,

without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM)

Suggested
(0:00).
Any help is greatly appriciated. Thanks.






  #7   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Time Display in a Stop Watch fromat

I guess the problem that I am running into is that when I try to add 13:00
hours plus 13:00 hours which should be (26:00 hours) excel displays the time
as 2:00AM? I have tried all kinds of formats, but i can't seem to find any
that will count the hours up? I am trying to find out how many total hours
an individual worked throughout the week based on the times the indivual
clocked in and out.

A1 (7:00:00 AM), B1 (8:00:00 PM), C1 (=A1-B1+(A1<B1)) C1 displays 13:00,
A2 (7:00:00 AM), B2 (8:00:00 PM), C2 (=A1-B1+(A1<B1)) C2 displays 13:00
as well, C3 (=SUM(C1,C2)) C3 displays 2:00? How can I get it to
display 26:00?

Any suggestions? Your help is greatly appriciated. Thanks.

Gabe

"Peo Sjoblom" wrote:

How would it tell the difference between 340 as in 03:40 or 340 as in the
integer 340?

--

Regards,

Peo Sjoblom

"Gabe" wrote in message
...
Thanks for the info, but I think I figured it out. Excel stores dates and
times as serial numbers. I have to input the correct dates as well

otherwise
it is trying to subtract the past. Example: 1pm 1/1/1900 from 12am

1/1/1900.
It's too bad excel does'nt have a basic stop watch format, maybe they

should
make one in a new version. Thanks.

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gabe" wrote in message
...
I am looking to have the formula bar read 0:00 as well. So when I

click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00,

2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format,
without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM)

Suggested
(0:00).
Any help is greatly appriciated. Thanks.







  #8   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Time Display in a Stop Watch fromat

Okay I figured it out, C3 must be in the following format. [hh]:mm

Thanks Anyway

Gabe

"Gabe" wrote:

I guess the problem that I am running into is that when I try to add 13:00
hours plus 13:00 hours which should be (26:00 hours) excel displays the time
as 2:00AM? I have tried all kinds of formats, but i can't seem to find any
that will count the hours up? I am trying to find out how many total hours
an individual worked throughout the week based on the times the indivual
clocked in and out.

A1 (7:00:00 AM), B1 (8:00:00 PM), C1 (=A1-B1+(A1<B1)) C1 displays 13:00,
A2 (7:00:00 AM), B2 (8:00:00 PM), C2 (=A1-B1+(A1<B1)) C2 displays 13:00
as well, C3 (=SUM(C1,C2)) C3 displays 2:00? How can I get it to
display 26:00?

Any suggestions? Your help is greatly appriciated. Thanks.

Gabe

"Peo Sjoblom" wrote:

How would it tell the difference between 340 as in 03:40 or 340 as in the
integer 340?

--

Regards,

Peo Sjoblom

"Gabe" wrote in message
...
Thanks for the info, but I think I figured it out. Excel stores dates and
times as serial numbers. I have to input the correct dates as well

otherwise
it is trying to subtract the past. Example: 1pm 1/1/1900 from 12am

1/1/1900.
It's too bad excel does'nt have a basic stop watch format, maybe they

should
make one in a new version. Thanks.

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gabe" wrote in message
...
I am looking to have the formula bar read 0:00 as well. So when I

click on
the cell I can just type 1,230,3,etc.. and it will appear as 1:00,

2:30,
3:00. just like a stop watch would. Any tips?

"David Billigmeier" wrote:

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format,
without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM)

Suggested
(0:00).
Any help is greatly appriciated. Thanks.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Quest with Time!! Philip Excel Worksheet Functions 4 August 24th 05 01:09 PM
How to use solver to schedule part time and full time workforce? The Ooz Excel Discussion (Misc queries) 0 August 18th 05 06:53 AM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 12:57 PM
How do I stop Excel from closing the open file each time I open a. Welsin Setting up and Configuration of Excel 3 January 9th 05 12:16 AM
Can't stop time duration [hh]:mm:ss converting to time of day Jack Cutrone Excel Discussion (Misc queries) 7 December 28th 04 12:23 AM


All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"