Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default adding time

A1:
0:15
A2:
0:30
A3:
=A1+A2

--
Kind regards,

Niek Otten

"Rgollar" wrote in message
...
im trying to put in a1 15 minutes and then in a2 30 minutes and then have
a3
add the total of a1 and a2 and show 45 minutes any help would be greatly
appreciated. thanks in advance



 
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
Help with Adding Time Hrs and Mins Mike Busch Excel Discussion (Misc queries) 1 November 23rd 05 04:24 PM
Adding time trucker New Users to Excel 1 November 22nd 05 10:18 PM
Entering Times Denise Excel Discussion (Misc queries) 9 November 15th 05 04:57 PM
adding in time formats rvnwdr Excel Discussion (Misc queries) 1 May 31st 05 11:38 PM
Adding time to multiple cells using TIMECODE timroutledge Excel Discussion (Misc queries) 1 May 25th 05 06:24 PM


All times are GMT +1. The time now is 04:26 PM.

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

About Us

"It's about Microsoft Excel"