Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Elizabeth
 
Posts: n/a
Default ADD TIME IN EXCESS OF 24 HOURS

i want to input time as hh:mm and add this together carrying the total
forward. When i go over 24 hours the figure resets to zero
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Actually only the display starts over again, the numbers are there, use
custom format [hh]:mm or for decimal hours multiply with 24 and format as
general


Regards,

Peo Sjoblom

"Elizabeth" wrote:

i want to input time as hh:mm and add this together carrying the total
forward. When i go over 24 hours the figure resets to zero

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
How to show negative time (e.g. -10 hours) Arhippa Excel Worksheet Functions 3 January 19th 05 08:53 AM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM
in excel totaling weekly hours military time mel Excel Worksheet Functions 1 January 17th 05 04:24 PM
time format multiplied by hours worked ? Brett Excel Worksheet Functions 2 January 11th 05 01:11 AM
Subtracting paid hours from unpaid hours ejerry7 Excel Worksheet Functions 5 November 29th 04 04:16 AM


All times are GMT +1. The time now is 09:05 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"