#1   Report Post  
Posted to microsoft.public.excel.misc
Malar
 
Posts: n/a
Default time difference

I wants to calulate the time difference for log in & log out

eg person scheuled logs out 14:00 & logs out 14:30
person scheduled logs out 13:00 logs out 12:55

  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default time difference

Just subtract one from the other

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Malar" wrote in message
...
I wants to calulate the time difference for log in & log out

eg person scheuled logs out 14:00 & logs out 14:30
person scheduled logs out 13:00 logs out 12:55



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
Calculating time difference over midnight! sygazelle Excel Discussion (Misc queries) 4 September 29th 05 04:59 PM
How can I use a time difference in a subsequent formula in Excel? numberman37 Excel Worksheet Functions 10 July 26th 05 07:42 PM
Time Difference Jennifer Excel Worksheet Functions 2 December 22nd 04 04:00 PM
What is the formula for getting time difference e.g. ("4 hrs 15 m. Sandeep Manjrekar Charts and Charting in Excel 3 December 4th 04 05:18 AM
Time / Formula to look at time difference carl Excel Worksheet Functions 5 November 8th 04 06:59 PM


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