| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding times
Hi there,
Anyone able to tell me how to add times minutes and seconds so that the answer will show hours minutes and seconds. Any hints on the best way to format the cells to show times would be great. Thank you! -- Bobby |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding times
Say A1 = 11:30:10 B1 = 15:30:10 C1 = =SUM(A1:A2) = 27:00:20 More help on time on the attached link http://www.cpearson.com/excel/datetime.htm VBA noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=568796 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding times
Sorry Forget to say to format sum cell as [H]:MM in custom formats VBA noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=568796 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding times
Hey Noob, Thanks. #Why did I think it waz so much more complicated. I had
looked at the website but confused myself. Good place this. thanks again -- Bobby "VBA Noob" wrote: Sorry Forget to say to format sum cell as [H]:MM in custom formats VBA noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=568796 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding times together | Excel Discussion (Misc queries) | |||
| Adding dates and times | Excel Discussion (Misc queries) | |||
| help neede with adding times | Excel Discussion (Misc queries) | |||
| Adding Times | Excel Worksheet Functions | |||
| Adding times together | Excel Worksheet Functions | |||
Linear Mode
