Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
I want my worksheet to display the following time format....
Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
C2: = B2-A2
format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
One way would be to have two Command BUttons - "Start" and "Finish"
Highlight the affected cells. Click "Format\Cells\Time\13:30" in Cell "C" = B2 - A2 In a module: Sub CommandButton1_Click() ' "Start" Range("A2").activate Activecell = Now() End Sub Sub CommandButton2_Click() "Finish" Range("B2").activate Activecell = Now() End Sub -- Best wishes, Jim "DB" wrote: I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
Bob......when I goto format...the option is Time and then the available
choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not
already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
Got it Jim...
again tho......if I input 7.45...it displays 10.48.... is it anything to do with world time differences ? Dave :) "Jim Jackson" wrote in message ... If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
That could be. I will work on this at home tonight (getting ready to leave
work for the day) and, hopefully, have an answer that works. )Unless someone else beats me to it.) -- Best wishes, Jim "DB" wrote: Got it Jim... again tho......if I input 7.45...it displays 10.48.... is it anything to do with world time differences ? Dave :) "Jim Jackson" wrote in message ... If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
Cheers Jim....your help is much appreciated..
Dave :) "Jim Jackson" wrote in message ... That could be. I will work on this at home tonight (getting ready to leave work for the day) and, hopefully, have an answer that works. )Unless someone else beats me to it.) -- Best wishes, Jim "DB" wrote: Got it Jim... again tho......if I input 7.45...it displays 10.48.... is it anything to do with world time differences ? Dave :) "Jim Jackson" wrote in message ... If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
You enter time as 7:45 not 7.45. Excel translates 7.45 as 7.45 days, which
is 10:48 on 7th Jan 1900. "DB" wrote in message k... Got it Jim... again tho......if I input 7.45...it displays 10.48.... is it anything to do with world time differences ? Dave :) "Jim Jackson" wrote in message ... If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Time
Agghhhh!!
Got it now...... Many thanks for all your help.... Everythings working smooth now............. Cheers All Dave :))))))))))))) "Bob Phillips" wrote in message ... You enter time as 7:45 not 7.45. Excel translates 7.45 as 7.45 days, which is 10:48 on 7th Jan 1900. "DB" wrote in message k... Got it Jim... again tho......if I input 7.45...it displays 10.48.... is it anything to do with world time differences ? Dave :) "Jim Jackson" wrote in message ... If you choose "Custom" instead of "Time" you can insert "hh:mm" if it is not already a choice. -- Best wishes, Jim "DB" wrote: Bob......when I goto format...the option is Time and then the available choices are HRS/Mins/Seconds..... Im selecting the area im using,,,,,,then in the Blue'd out area......right click......select Time....... but it includes seconds.......and if I type something like 07.45 it gets displayed as 10.48.00 AM Whats happening....I'm a bit confused Dave :)) "Bob Phillips" wrote in message ... C2: = B2-A2 format as hh:mm "DB" wrote in message k... I want my worksheet to display the following time format.... Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |