Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mschertz
 
Posts: n/a
Default I need to add and subtract time cells. ie. 13:45 minus 13:58

I am having trouble manipulating cells formated to time. I need to be able
to add, sum, subtract the entered cells, and then work with the results of
the addition etc.
  #2   Report Post  
Alan
 
Posts: n/a
Default I need to add and subtract time cells. ie. 13:45 minus 13:58

To add times and prevent them being converted into days, Cusstom Format as
[hh]:mm:ss
Regards,
Alan.
"Mschertz" wrote in message
...
I am having trouble manipulating cells formated to time. I need to be able
to add, sum, subtract the entered cells, and then work with the results of
the addition etc.



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



All times are GMT +1. The time now is 06:47 AM.

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"