Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 131
Default Time difference btwn entries

Just wondering if there a way to calculate the time from one entry to the
other entry?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Time difference btwn entries

A1 = StartTime
B1 = End Time
C1 = B1-A1
Format Cells -- Custom format C1 to [h]:mm

--
If this post helps click Yes
---------------
Jacob Skaria


"Kashyap" wrote:

Just wondering if there a way to calculate the time from one entry to the
other entry?

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
subtract the time difference from another time difference Dannigirl Excel Discussion (Misc queries) 3 September 30th 07 03:47 PM
Time difference calculations, daylight savings time, Excel Tim Excel Discussion (Misc queries) 1 December 28th 06 04:18 PM
Difference between two date entries in excel? Novell Excel Discussion (Misc queries) 2 October 17th 06 07:41 AM
Calculate the difference between two cell entries using NOW() func CZeigler Excel Worksheet Functions 1 July 7th 06 05:53 PM
Btwn to date entries dave Excel Worksheet Functions 1 November 12th 04 05:17 PM


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