Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datetime field

Status
Not open for further replies.
demopro

demopro

Programmer
Apr 23, 2001
117
US
Hello,

I have two datetime fields (created, modified) and a calculated field (Time Taken). The Time Taken field is the difference between the Modified and Created fields. The code I am using is below.

Code: 
=IF(NOT(ISBLANK([Modified])),([Modified]-[Created])*24,0)

This works fine for me in giving me the total hours between created and modified, but the problem I am having is when the Time Taken field goes over 24 hours I would want it to display 1 Day, 2:32 instead of 26:32

Thanks,
Demopro
 
Status
Not open for further replies.

Similar threads

doburton
  • Locked
  • Question
Sharepoint List Using Excel - Calc Field Adds Blank rows
Replies
0
Views
162
doburton
doburton
pho01
  • Locked
  • Question
Sharepoint: How to enable a field when a check box is selected on new item form?
Replies
3
Views
184
ehaze
ehaze
SpeedBWild
  • Locked
  • Question
looking for projected field functionality for a textbox similar to ootb lookup field
Replies
0
Views
69
SpeedBWild
SpeedBWild
katoc
  • Locked
  • Question
Using a calculated Date field for Due Date in a Three-state workflow
Replies
2
Views
102
katoc
katoc
SmithyJD
  • Locked
  • Question
Sharepoint list title field
Replies
2
Views
77
SmithyJD
SmithyJD

Part and Inventory Search

Sponsor

Back
Top