LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default How do I write a formula in excel that will calculate time?

Give an example.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"stacy" wrote in message
...
I am trying to use a excel worksheet to first lookup times and if thoose
times are between then they subtract? On my worksheet I have signin time

and
signout time, I need to be able to write a formula the will seperate the

time
into which periods they missed? any suggestions



 
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
can excel calculate time increments in a formula? lmunzen Excel Worksheet Functions 2 September 11th 06 09:39 PM
write a formula to calculate age in yrs; 04/30/06 minus birthdate yancey04 Excel Worksheet Functions 8 January 28th 06 10:00 PM
How do I write an Excel formula to calculate my working time? GregJ Excel Worksheet Functions 3 December 27th 05 01:48 PM
How do I write the formula to calculate someones time worked deusy Excel Worksheet Functions 3 November 16th 05 08:49 PM
how do i calculate time in & out in excel using a formula pjsbh652005 Excel Worksheet Functions 0 September 13th 05 04:00 AM


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