Replies

Can I ask why you would want to do this in one cell? You’re pretty much defeating Excel that way.

Hi again all..

Okay I will attempt to make myself clearer…

When I arrive in my office in the morning I am confronted with dozens of timesheets, on these timesheets it lists the drivers hours and ALSO their ‘Periods of Availability’. Whilst inputting their ‘POA’ data I am trying to insert the hours and minutes into my spreadsheet in the format in which it is shown on their timesheets. ie:

Monday – 1hr 42 minutes
Tuesday – 2hr 32minutes
Wednesday 3hr 49 minutes…etc

I do not wish to put in the number as: =1+42/60+2+32/60..etc
I would like to insert as: 1:42+2:32+3:49..etc

This can partially be done in the cell formatting using [h]:ss command, but it will NOT allow me to use the same formatting to add them all together in the same cell..

I hope you understand….

kind regards

Steve Gulliver – Southampton UK

You can put them all into hours:

=1.5 +2 +.75+…

or even (if desired)

=1+30/60 + 2 + 45/60 +….

Steve

Thanks very much for the rapid response, that would certainly work up to a point. I think I may have phrased it incorrectly with a poor example.

I would like to be able to add up in hours and minutes and set of number such as. 1 hr 32 mins + 3 hrs 19 mins + 19 hrs 13 mins, not just easily rounded numbers like .25 or .45 etc.. I am attempting to get the spreadsheet to work out the answer for me, I am aware that I can just make 3hrs 19 mins into 199mins then divide by 60. However I am looking for a way of just inserting the hours and minutes into the cell as I have them put in front of me by a work colleague.

Hope I have made it a little clearer to all…

kind regards

Steve Gulliver – Southampton UK

Thank you very much indeed for replying.

Steve Gulliver
Southampton UK

Hello to you sir,

thank you very much for taking the time and effort to ascertain what this file was, I went back to work this morning and had another look around our network, and found that SGOedit.ocx is a Saga Accounts file. So all is okay.

Once again thanks very much for your help.

kind regards

Steve Gulliver

Southampton UK

Thank you very much indeed gentleman, I have used the formatting option. And it works fine..

kind regards

Steve Gulliver
Southampton UK

Hi Guys

thanks very much for your help, I have inserted the routine you suggested, I think it’s almost there, however I think I must be doing something slightly wrong? When I put in this command it changes ALL my existing drivers on the database some 400 or so… Wonder if you chaps have any other ideas…

kind regards

Steve Gulliver
Southampton UK

Hi HanV,

yes it is the labels…..the strange thing is that other parts of the screen are clear, and I am using the same font…I was wondering if there is a better font to use…

thanks Steve

Once agains Hans…thanks very much for your time and expertise…Steve

Worked at treat!!
Thank you very much indeed HanV for you help…..

Hare Krysna…Steve – Southampton UK

My goodness what a swift response!!
Okay I have a label on my form called label247, when I click this label it starts up an [eventprocedure] as follows:
Private Sub Label247_Click()
Application.FollowHyperlink “mailto: [Emailaddress]”
End Sub

The email address is in another field named : Emailaddress….
After this my brain begins to hurt… thanks Steve