#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default adding time in excel

hey all,
is there way to add time in excel?
for instance,
i want to take 58 min and add 3min giving 61min.

thanks,
rodchar
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default adding time in excel

Hi,

I think there's a banana skin waiting for me here because these don't look
like formatted times to me but supposing they are then it's simple addition

=a1+a2

formatted as [mm].ss

Mike

"rodchar" wrote:

hey all,
is there way to add time in excel?
for instance,
i want to take 58 min and add 3min giving 61min.

thanks,
rodchar

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default adding time in excel

sorry bout that, should have phrased it better...
turns out i can do
15:34 + 0:20 to give me what i need.

"Mike H" wrote:

Hi,

I think there's a banana skin waiting for me here because these don't look
like formatted times to me but supposing they are then it's simple addition

=a1+a2

formatted as [mm].ss

Mike

"rodchar" wrote:

hey all,
is there way to add time in excel?
for instance,
i want to take 58 min and add 3min giving 61min.

thanks,
rodchar

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
Figuring and adding time in Excel tnal Excel Worksheet Functions 2 July 3rd 08 04:40 PM
Adding hours to time in Excel [email protected] New Users to Excel 6 May 11th 07 10:50 PM
Adding time Values up in Excel John Excel Worksheet Functions 4 September 13th 05 02:55 PM
Adding time in Excel MovieSchedules Excel Worksheet Functions 1 January 31st 05 10:18 AM
Adding time in Excel tahirab Excel Worksheet Functions 1 November 10th 04 09:47 PM


All times are GMT +1. The time now is 10:57 AM.

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"