Register    Login    Forum    Search    FAQ    Donate    Amazon Affiliate

Board index » General




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Adding Time In Numbers
 Post Posted: Wed Oct 25, 2017 7:59 pm 
Offline
User avatar

Joined: Thu Oct 07, 2010 4:36 pm
Posts: 1248
Location: Warrington
Anyone know how I can add a column of times(HH:MM:SS) in numbers?

I can find plenty of info on how to enter values in cells so that they add, but my times are downloaded to my Mac as a CSV file with the times already entered.

_________________
Image
Home: PPC Mac Mini, 10.4.11, Intel Mac Mini 10.6.8, MacBook Pro(mid 2012): 12Gb, 10.11.5, White MacBook 10.8.4
iPhone 5S, iOS10 Vodafone PAYG


Top 
 Profile  
 
 Post Posted: Wed Oct 25, 2017 8:11 pm 
Offline
User avatar

Joined: Fri Jul 17, 2015 7:22 pm
Posts: 1391
Location: S.W. Wales
Not sure if this is what you mean but highlight the column, pick the Cell tab in the right pane, Data format - Date & Time, Date - None, Time - MM:MM:SS.


Top 
 Profile  
 
 Post Posted: Wed Oct 25, 2017 10:02 pm 
Offline
User avatar

Joined: Thu Oct 07, 2010 4:36 pm
Posts: 1248
Location: Warrington
Thank. That's fine but I need to be able to add up all the times in those cells in that column.

_________________
Image
Home: PPC Mac Mini, 10.4.11, Intel Mac Mini 10.6.8, MacBook Pro(mid 2012): 12Gb, 10.11.5, White MacBook 10.8.4
iPhone 5S, iOS10 Vodafone PAYG


Top 
 Profile  
 
 Post Posted: Thu Oct 26, 2017 8:21 am 
Offline

Joined: Wed Dec 22, 2010 9:07 pm
Posts: 1101
Location: In a turkey shed.
Format cell data format as "duration" Choose "custom units"

_________________
G4 Powermac Quicksilver Dual 800MHz OSX 10.5.8
iMac 27" i7 2.93 GHz quad core OSX 10.12.6
13" Macbookpro OSX 10.10.3
17" Macbookpro OS X 10.12.6
iPhone 5S iOS11
Original iPad wifi


Top 
 Profile  
 
 Post Posted: Sat Oct 28, 2017 8:15 pm 
Offline
User avatar

Joined: Thu Oct 07, 2010 4:36 pm
Posts: 1248
Location: Warrington
Thanks Paw. It seems that I can only do that in an empty cell. If I do it in cells that already have a time entered, the cell doesn't hold the new format when you click away from it and then come back to it.

_________________
Image
Home: PPC Mac Mini, 10.4.11, Intel Mac Mini 10.6.8, MacBook Pro(mid 2012): 12Gb, 10.11.5, White MacBook 10.8.4
iPhone 5S, iOS10 Vodafone PAYG


Top 
 Profile  
 
 Post Posted: Sat Oct 28, 2017 9:50 pm 
Offline

Joined: Wed Dec 22, 2010 9:07 pm
Posts: 1101
Location: In a turkey shed.
Bugger. What happens with freshly imported data into a pre-formatted table? How many tables do you need to change?

_________________
G4 Powermac Quicksilver Dual 800MHz OSX 10.5.8
iMac 27" i7 2.93 GHz quad core OSX 10.12.6
13" Macbookpro OSX 10.10.3
17" Macbookpro OS X 10.12.6
iPhone 5S iOS11
Original iPad wifi


Top 
 Profile  
 
 Post Posted: Sun Oct 29, 2017 10:07 pm 
Offline
User avatar

Joined: Thu Oct 07, 2010 4:36 pm
Posts: 1248
Location: Warrington
I'm not looking for freshly imported data. The data I have is timed 'phone calls downloaded from TalkTalk as a CSV file, so the data is already there.

I was just looking for a quick way to add then up.

_________________
Image
Home: PPC Mac Mini, 10.4.11, Intel Mac Mini 10.6.8, MacBook Pro(mid 2012): 12Gb, 10.11.5, White MacBook 10.8.4
iPhone 5S, iOS10 Vodafone PAYG


Top 
 Profile  
 
 Post Posted: Mon Oct 30, 2017 2:19 pm 
Offline

Joined: Wed Dec 22, 2010 9:07 pm
Posts: 1101
Location: In a turkey shed.
What I meant was create a formatted table to import the CSV file into rather than try to change to formatting after importing.

_________________
G4 Powermac Quicksilver Dual 800MHz OSX 10.5.8
iMac 27" i7 2.93 GHz quad core OSX 10.12.6
13" Macbookpro OSX 10.10.3
17" Macbookpro OS X 10.12.6
iPhone 5S iOS11
Original iPad wifi


Top 
 Profile  
 
 Post Posted: Mon Oct 30, 2017 2:44 pm 
Offline
User avatar

Joined: Fri Jul 17, 2015 7:22 pm
Posts: 1391
Location: S.W. Wales
If I understand what you want to do correctly (and I still may be wrong), you are Donald Ducked trying this in Numbers. Microsoft Excel can handle time. Have a look at this MS support page.

The bad news - Excel costs. The good news - LibreOffice does the same for free (I just tried the examples). Sorry if I'm a time waster with this post.


Top 
 Profile  
 
 Post Posted: Mon Oct 30, 2017 5:09 pm 
Offline

Joined: Wed Dec 22, 2010 9:07 pm
Posts: 1101
Location: In a turkey shed.
loughor wrote:
If I understand what you want to do correctly (and I still may be wrong), you are Donald Ducked trying this in Numbers. Microsoft Excel can handle time. Have a look at this MS support page.

The bad news - Excel costs. The good news - LibreOffice does the same for free (I just tried the examples). Sorry if I'm a time waster with this post.

What David wants to do can be done in Numbers if he can get the data formatted correctly.
Numbers will add a column of hh:mm:ss (duration) if that is how it is entered. It won't add them if it's entered as time (of the day).

_________________
G4 Powermac Quicksilver Dual 800MHz OSX 10.5.8
iMac 27" i7 2.93 GHz quad core OSX 10.12.6
13" Macbookpro OSX 10.10.3
17" Macbookpro OS X 10.12.6
iPhone 5S iOS11
Original iPad wifi


Top 
 Profile  
 
 Post Posted: Wed Nov 01, 2017 8:50 pm 
Offline
User avatar

Joined: Thu Oct 07, 2010 4:36 pm
Posts: 1248
Location: Warrington
Thanks, Paw. I'll look at creating a formatted table, but I'm beginning to think it might be simpler just to add the time use Calculator.

_________________
Image
Home: PPC Mac Mini, 10.4.11, Intel Mac Mini 10.6.8, MacBook Pro(mid 2012): 12Gb, 10.11.5, White MacBook 10.8.4
iPhone 5S, iOS10 Vodafone PAYG


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 11 posts ] 

Board index » General


Who is online

Users browsing this forum: No registered users and 2 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 

HTML tutorial